If you copy it directly from within the source formula bar, and then paste it
directly into the destination cell's formula bar, does that achieve the
desired results for you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"DS" wrote:
I created a pretty long formula that use VLOOKUP/HLOOKUP's referencing ranges
in another worksheet. When I copy/paste the formula to other cells, it
changes the parameters of the range. How can I copy/paste without it
changing the ranges?