Excel VBA - Activate & Select

Excel VBA - Activate & Select
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[AshrafAli-ihoy]

you are teaching us from basic to advance good job very helpfull

[henrymuasml]

very nice! from basic to advanced level!

[ManpreetSingh-jbrr]

Hello, It is very helpful the way you teaching and easy to understand.
Can we get the same excel on which you are working will very helpful for us.

[Kabhinaykumar]

could you please mentions what difference between select & activate

[kavyak]

Hii sir i have a doubt that if I using of data in workbook of 1 sheet for this data can i run the program in same workbook of other sheet.

[JenifRaj]

What is the difference between select a cell& activate a cell exactly?

[shekhabdul]

what is the difference between select and activate.

[nextstep]

Hi Sir,

Can you share the spreadsheet for practice

[BharatiyaFirstThanHinduMuslim]

What is the difference between range(a1).activate and range(a1). select.

[Karthikng]

'My Reference
Range("A1").Select
Range("A1").Activate

[alkaamin]

Window-10.excel (365) - I am getting run time error.

[gokulpasari]

hello Sir and Audience
I used a VBA code to select the next blank in Column 1 but instead, it selects the (1000, 1) cell
here is the code,

Private Sub CommandButton1_Click()

For i = 5 To 1000

If Worksheets("DailyTruckRecords").Cells(i, 1).Value = "" Then
Cells(i, 1).Select

End If


Next

End Sub