Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy range without changing formulas?
I have a range of cells with formulas that include (and must have)
relative references. I want to copy that range to another area, retaining the formulas exactly as written. Is there an easy way to accomplish that? The only way I know is to copy the "text" of each cell one by one; that is, activate each cell, copy from the fx field, then paste into the new cell. That is too tedious for the number of cells involved. I could write a macro to accomplish the task. But that would take me more time than the manual copy (albeit less error prone) because I am not conversant in VBA -- even with the aid of macro recording. Is there an easier way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record changing cell data into a column or range | Excel Worksheet Functions | |||
Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
Why are formulas not updating when changing a value in the range? | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) |