global freeze?

  • Thread starter Thread starter Deirdre
  • Start date Start date
D

Deirdre

I have cells which I want to "freeze" by inserting the $
before and after the column letter - but thousands and
thousands of them - to enable me to create a macro to
automatically capture the data and paste it to another
area for printing without changing the formulas. I can't
figure out a global replace option - unless there is a
wild card option to replace the first part of the formula
before the row reference, but leave the row numbers
alone. help? thanks!
 
You could do a find and replace for each column which has data, provided you
have not used too many columns.
Edit|Replace... for Find What put the column letter and for Replace With put
the column letter preceded by the $.

tim
 
I agree with Gordon, his way is much better...I would've done it with a
macro were I doing it myself.

Thanks Gordon

tim
 
Back
Top