| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating macros
How do I build a macro to select a cell after the last cell in a column with
data, that will work when the number of rows in a worksheet changes from worksheet to worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating macros
With ActiveSheet lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row End With will give you the last filled row in Col A on the active sheet... "garygc" wrote: How do I build a macro to select a cell after the last cell in a column with data, that will work when the number of rows in a worksheet changes from worksheet to worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a macros and repeating it | Excel Discussion (Misc queries) | |||
| Creating macros with if stmts | Excel Discussion (Misc queries) | |||
| macros creating | Excel Discussion (Misc queries) | |||
| creating macros in excel | Excel Discussion (Misc queries) | |||
| Macros-creating new sheets | Excel Worksheet Functions | |||
Hybrid Mode
