Is there a formula that can automatically assign the "$" symbol to each cell
in column D to maintain formula integrity as follows:

=$A$2
=$A$3
=$A$4
=$A$5
etc..

Thanks.

Ed

"Max" wrote in message
...
How can I freeze column D's formulas before sorting?
To freeze, copy col D, then right-click on it Paste special Check
"Values" OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800, Files:359, Subscribers:56
xdemechanik
---