| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding ranges in macros
I have a block of data A1..G50. I'm using a macro to add additional rows one
at a time. How do I set it up to find row 51 for the first add? Using macro recorder, I started at cell A1 and used END DOWN and DOWN once more to get to A51. This works the first time, but when I run the macro again, it stops at A51 (should be A52 the second time). Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto-expanding chart- dynamic ranges | Excel Worksheet Functions | |||
| using named ranges in macros | Excel Discussion (Misc queries) | |||
| using named ranges in macros | Excel Discussion (Misc queries) | |||
| Using Query and expanding named ranges | Excel Discussion (Misc queries) | |||
| Named ranges in macros? | Excel Discussion (Misc queries) | |||
Threaded Mode
