| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I detect the first empty cell is column A
I need to copy information from worksheet A and put that information the
first blank cell of Column A in worksheet B in a macro. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I detect the first empty cell is column A
Hi, this will detect last row of column A on the current sheet.
Dim LastRow As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row -- Cheers Nigel "PJ0779" wrote in message ... I need to copy information from worksheet A and put that information the first blank cell of Column A in worksheet B in a macro. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Go To the next empty cell in Column A | Excel Worksheet Functions | |||
| detect empty cell | Excel Programming | |||
| Detect whether a row is completely empty | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
Linear Mode
