Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel macro-copy formula to entire column?
i have a large amount of data i need to graph each week. The amount of data
varies each week. I would like to have a macro which creates a formula and puts it in an adjacent cell to all the rows with data. I have created macros for this, but it always pastes the formula in the number of rows i had in the spreadsheet when i created the macro. For instance, when i record the macro i had 32000 rows. It pastes the formula in rows 2-32,000. When i pul in new data with 31000 rows, it is still pasting the formula in rows 2-32,000. How do I get the macro to only paste in the relative rows? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro Help | Excel Discussion (Misc queries) | |||
Is this possible with excel ? | Excel Discussion (Misc queries) | |||
formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Copy one cell to entire column | Excel Discussion (Misc queries) |