Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the VB code for autofilling relative cells?
I have recorded a macro, and one of my procedures requires using the
autofill feature. Even thought I selected "relative" values when I began recording, the auto fill used the absolute values. Now when I run the macro on worksheets with more data, it only autofills up until the row I recorded the macro with. In other words, I would like to convert this code: Selection.AutoFill Destination:=ActiveCell.Range("A1:A5") to read something like this: Selection.AutoFill Destination:=ActiveCell.Range("A1:The entire length the previous column") Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for autofilling cells below identically | Excel Discussion (Misc queries) | |||
How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
Relative Cell References within VBA code | Excel Discussion (Misc queries) | |||
autofilling cells | Excel Worksheet Functions | |||
Code to enter formula w/ relative row ref? | Excel Programming |