cell and column selections Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
AKTİF SÜTUNU SEÇ
Sub SelectEntireColumn()
Selection.EntireColumn.Select
End Sub
AKTİF SATIRI  SEÇ
Sub SelectEntireRow()
Selection.EntireRow.Select
End Sub
TÜM HÜCRELERİ SEÇ
Sub SelectEntireSheet()
    Cells.Select
End Sub
DOLU HÜCRELERİN ALTINDAKİ BOŞ HÜCREYİ SEÇER
Sub ActivateNextBlankDown()
ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
End Sub
AKTİF HÜCRELERİN SAĞ TARAFINDAKİ  BOŞ HÜCREYİ SEÇER
Sub ActivateNextBlankToRight()
ActiveCell.Offset(0, 1).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(0, 1).Select
Loop
End Sub
AKTİF HÜCRENİN SAĞINDAKİ VE SOLUNDAKİ DOLU HÜCRELERİ SEÇER
Sub SelectFirstToLastInRow()
Set LeftCell = Cells(ActiveCell.Row, 1)
Set RightCell = Cells(ActiveCell.Row, 256)
If IsEmpty(LeftCell) Then Set LeftCell = LeftCell.End(xlToRight)
If IsEmpty(RightCell) Then Set RightCell = RightCell.End(xlToLeft)
If LeftCell.Column = 256 And RightCell.Column = 1 Then ActiveCell.Select Else Range(LeftCell, RightCell).Select
End Sub
AKTİF HÜCRENİN ALTINDAN BAŞLAYARAK EN SON HÜCREYE KADAR SEÇER
Sub SelectDown()
Range(ActiveCell, ActiveCell.End(xlDown)).Select
End Sub
A1:A3 VE C3:C8 HÜCRE ARALIĞINI SEÇER
Sub hucresec()
Application.ScreenUpdating = False
Dim r1 As Range, r2 As Range, rAll As Range
Set r1 = Range("A1", "A3")
Set r2 = Range("C3", "C8")
Set rAll = Union(r1, r2)
rAll.Select
End Sub
Aktif hücrenin 3 satır altındaki, iki sütun önündeki hücreyi seçer
Sub MoveToCell()
ActiveCell.Offset(3, 2).Select
End Sub

No	Macro Name
1	cell and column selections
2	cell column selections
3	excel operators hk
4	write the days of this month to the right write the day to the child cell and color the weekends
5	If you start vba, open the vba library and use the sheet / page to skip 7 columns
6	Copy and paste cell values by shortcut
7	Adding Rows and Total Formula When Cell Changes
8	write the number you want to be colored on the sheet / page in msgbox
9	Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
10	search color
11	Automatically resize row width when cells are merged
12	Expand the selected area by one more cell fill the old region with more cells
13	Put an asterisk at the beginning of the cell
14	If the inside of the cell is red writings get white color.and get obedience and bold
15	select by intersecting full row and column (perfect)
16	selects from top to bottom if the column contains data
17	Remove Characters from a Directory: Remove only characters from the beginning of a text string. All you need is to reference a cell or add a number of characters and text to the function to remove from the text string. There are two arguments,rng" for the text string andcnt" for the number of characters to remove. for example: 1 incnt if you want to remove the first characters from a cell;
18	to delete sales with faulty cells
19	gives the address and type of formula if the active cell contains a formula
20	Track and Report User Changes in an Excel worksheet or workbook

Excel Free Macros (VBA)

Cell And Column Selections

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords