Macro for Select next line

Closed

Sugu - Jun 15, 2010 at 06:26 AM
rizvisa1 Posts 4478 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

Macro for Select next line
Vba select case like - Guide
How to select at the rate in laptop - Guide
Please insert the correct dvd-rom select ok and restart application nfsmw ✓ - Video Games Forum
How to select all in close friends on instagram - Instagram Forum
DVD Rom issues - Drivers Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Why can't I bridge connect?

Cannot download multiple files at once in WhatsApp Web

How to bridge connections from laptop to pc

cannot get my home pc to bridge connections

i need help bridge connection

Similar discussions

Subscribe To Our Newsletter!