VBA In Basic Selection Copy Paste Method || VBA Macro in 30 Days in Hindi || Day -2

Описание: Excel VBA – Selecting Cells

Selecting Cells by Absolute Positions

1.Selecting Single Cells Using Range or Cells
2.Referring to the Active Cells
3.Selecting Multiple Cells

****************************************************
Sub selection()

Range("A13").Select
ActiveCell.Value = 11

Cells(13, 2).Select
ActiveCell.Value = "John"

[c13].Select
ActiveCell.Value = #6/23/2020#

End Sub


*******************************************************

Copy the value from one cell to another

Range("a1:e8").Copy Range("a10")

Copy values from one range of cells to another

Range("a1:e8").Copy Range("a10:e18")
Copy values from one worksheet to another

Worksheets("sheet1").Range("a1:e8").Copy Worksheets("sheet2").Range("a1")

*******************************************************
Selecting different cells :-
Sub example()
'Selecting A8 and C5
Range("A8, C5").Select
End Sub

Selecting a range of cells:-
Sub example()
'Selecting cells A1 to A8
Range("A1:A8").Select
End Sub

Selecting a cell by row and column number:-
Sub example()
'Selecting the cell in row 8 and column 1
Cells(8, 1).Select
End Sub

*********************************************

Sub Lastcelloflist()

Worksheets("Sheet1").Activate

Range("A1").Select

ActiveCell.End(xlDown).Select

ActiveCell.Offset(1, 0).Select

ActiveCell.Value = 11


End Sub

******************************************
Download the File from here -
https://drive.google.com/drive/folder...



Any Questions mail to:- [email protected]


‪@SharmajikaGyanTricks‬
#msexcel2016
#vbamacro
#exceltipshindi
#vbahindi