Excel ranges help

[MarcLister]

I've got about 75 similar formulae each with 8 defined ranges, eg C3:C33. I could do with having all 8 ranges in every formula to be changed from C3:C33 to $C$3:$C$33. Is there a way with Visual Basic to get Excel to run through all the formula with ranges in them iteratively and add the dollar signs only to the ranges for me?

 

[izzop]

Hi,

Can't you just use 'Replace' (Ctrl & F): - Replce 'C' with '$C'?

Regards

 

[MarcLister]

It wasn't working at the time for some reason. Then inevitably after I posted it was.