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
- Edit the code for the format table macro - Excel Forum
- To create a network bridge you must select ✓ - Network Forum
- How to select all in close friends on instagram - Instagram Forum
- Select the encoding that makes your document readable ✓ - Office Software Forum
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
