| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy range without changing formulas?
Gord Dibben wrote:
Select the range. EditReplace what: = with: ^^^ Replace all. Copy and paste to new area then reverse the editreplace steps in both spots. It ain't pretty, but it works great! Thanks. |
| Reply |
| 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) | |||
Hybrid Mode
