K
keith
I want to change all references to cells on work sheet 1, to absolute cell
references? Is there any way I can change every cell reference in every
formula in every cell in one go, or do I have to edit every single cell.
Example of sheet data:-
=IF(ISNA(BP$74),"VB","") to equal =IF(ISNA($BP$74,"VB","") etc.
(A$3,BP$3:BP$13,1,FALSE) to equal ($A$3,$BP$3:$BP$13,1,FALSE)
I'm using Office 97!!
Thanks Keith
references? Is there any way I can change every cell reference in every
formula in every cell in one go, or do I have to edit every single cell.
Example of sheet data:-
=IF(ISNA(BP$74),"VB","") to equal =IF(ISNA($BP$74,"VB","") etc.
(A$3,BP$3:BP$13,1,FALSE) to equal ($A$3,$BP$3:$BP$13,1,FALSE)
I'm using Office 97!!
Thanks Keith