| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Reference and AutoFill- Macro
I need to copy a formula in a new column for each row. When recording the
macro I am using the autofill function however each time I use this spreadsheet there will be a different number of rows. I need the autofill to adapt. The following is part of the script I think needs adjustment I just don't know how to adjust it. Thanks in advance for any ideas. Range("H2").Select Selection.AutoFill Destination:=Range("H2:H423") Range("H2:H423").Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative reference? in macro | Excel Worksheet Functions | |||
| Using relative reference in macro | Excel Discussion (Misc queries) | |||
| Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
| Relative reference in macro | Excel Programming | |||
| Relative Reference in a Macro | Excel Programming | |||
Threaded Mode
