Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding rows to spreadsheet after macro is written
I need to add some rows and / or columns to a spreadsheet. After I add the
columns / rows, the macros that I built blow up. I have tried adding $ signs to the cell references, ie: Range("D56") becomes Range ("$D$56), but this does not seem to work. In excel the formulas scale to reflect any row/col additions or deletions. Any thoughts on what I should do to the macro language to ensure that the macro changes and the layout of the sheet changes? Thanks -- sd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding new rows to an Excel spreadsheet | Charts and Charting in Excel | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Sum only adding rows on page instead of entire spreadsheet - help | Excel Discussion (Misc queries) | |||
running-total formulas written from one spreadsheet to another | Excel Programming | |||
Adding new rows to spreadsheet | Excel Programming |