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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 15, 2010 at 07:05 AM
Related:
- Macro for Select next line
- Vba select case like - Guide
- Spell number in excel without macro - Guide
- Reboot and select proper boot device - Laptop Forum
- To create a network bridge you must select at least two lan - Network Forum
- How to select at the rate in laptop - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 15, 2010 at 07:05 AM
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
Dim lLastRowA as long
lLastRowA = Cellls(Rows.Count, "A").End(xlup).Row
if Not isBlank(Cells(lLastRowA, "A")) then lLastRowA = lLastRowA + 1
