Macro for Select next line

Closed
Sugu - Jun 15, 2010 at 06:26 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2010 at 07:05 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 15, 2010 at 07:05 AM
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
0