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

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Aktif sütunu seç
Sub SelectEntireColumn()
Selection.EntireColumn.Select
End Sub
'Aktif satırı seç
Sub SelectEntireRow()
Selection.EntireRow.Select
End Sub
'Tüm hücreleri seç
Sub SelectEntireSheet()
    Cells.Select
End Sub
'Dolu hücrelerin altındaki boş hücreyi seç
Sub ActivateNextBlankDown()
ActiveCell.Offset(1, 0).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
End Sub
'Aktif hücrenin sağ tarafındaki boş hücreyi seç
Sub ActivateNextBlankToRight()
ActiveCell.Offset(0, 1).Select
Do While Not IsEmpty(ActiveCell)
ActiveCell.Offset(0, 1).Select
Loop
End Sub
'Aktif hücrenin sağındaki ve solundaki dolu hücreleri 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
'Aktif hücrenin altından başlayarak en son hücreye kadar seç
Sub SelectDown()
Range(ActiveCell, ActiveCell.End(xlDown)).Select
End Sub
'A1:A3 VE C3:C8 hücre aralığını seç
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 column selections
2	cell and column selections
3	excel operators hk
4	gives the address and type of formula if the active cell contains a formula
5	Adding Rows and Total Formula When Cell Changes
6	Track and Report User Changes in an Excel worksheet or workbook
7	zoom in and out when you select the active cell (cell c2)
8	Calculate the sum of cells with only a certain cell color
9	write the days of this month to the right write the day to the child cell and color the weekends
10	active cell notification
11	divides the text in the active cell into letters (divided by 3 characters into columns)
12	The operation of different macros in response to the data entered in the cell in column 5
13	separates the text in the active cell into letters (columns)
14	Selects the first empty cell after full cells. (For columns.)
15	Find the previous full cell from an empty cell
16	Find the first empty cell in column C
17	Click any cell in column a to give the row number
18	Colorize columns differently (Each column is the same color, but each row is different color.)
19	Expand the selected area by one more cell fill the old region with more cells
20	automatically opening the column to the desired width when you click on the cell 2

Excel Free Macros (VBA)

Cell Column Selections

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords