G
Guest
Hi,
I would like to design some code so that I can select a range of cells
containing formula that I wish to make absolute.
I would ideally like it to function like the F4 key which allows the $ to be
put in to absoute by row and column, row and finally column.
The F4 key only does it for each precedent contained in the formula string
and you have to select the one you want to change. However my code will not
want to distinguish between precedents - I just want to absolute all of them
in each cell contained in the selected range.
Any help is appreciated....Chris
I would like to design some code so that I can select a range of cells
containing formula that I wish to make absolute.
I would ideally like it to function like the F4 key which allows the $ to be
put in to absoute by row and column, row and finally column.
The F4 key only does it for each precedent contained in the formula string
and you have to select the one you want to change. However my code will not
want to distinguish between precedents - I just want to absolute all of them
in each cell contained in the selected range.
Any help is appreciated....Chris