Hello,

I created a spreadsheet that was fairly repetitive, and now a macro I wrote is going to automatically sort some fields that are based off of a formula. Normally I would add a $ in the formulas to lock down the inputs, but because I was coping down the series I could not use the $. I would now like to go through and add the $ into many fields at once, is there a way to do this with out manually going to each cell and typing them in?

Thanks,
Nik