Soldato
- Joined
- 7 Mar 2005
- Posts
- 19,605
- Location
- LU7
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?
Last edited:
