Thread: How to copy range without changing formulas?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
  
Posts: 40
Default 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 With QuoteReply With Quote