Macro for Select next line [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need help, i have macro in that file Column A already i have 10 lines of data. again i have to include few data for that how can i fine next empty cell to paste next data in that file . What is the code for the Macro.

Regards
Sugumar.P



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
If you want to see next blank cell in column A then


Dim lLastRowA as long

lLastRowA = Cellls(Rows.Count, "A").End(xlup).Row

if Not isBlank(Cells(lLastRowA, "A")) then lLastRowA = lLastRowA + 1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!