Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making autofill range dynamic
Hi. For the following code:
Range(Selection, Selection.End(xlDown)).Select Selection.AutoFill Destination:=Range("A4:A11"), _ Type:=xlFillDefault I am trying to figure out a way to make the Range not specify A4:A1 because each time the macro is run, it should go down a cell. Fo instance, the next time it is run, the Range should read A4:A12. Ho do I do that? Thanks in advance for helping me out with this! -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Autofill | Excel Discussion (Misc queries) | |||
Dynamic range for autofill macro | Excel Discussion (Misc queries) | |||
Making condition dynamic? | Excel Discussion (Misc queries) | |||
autofill with dynamic range | Excel Programming | |||
autofill with dynamic range again | Excel Programming |