making a range of cell formula absolute
 

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

making a range of cell formula absolute
 

Look in VBA HELP for CONVERTFORMULA

--
Don Guillett
SalesAid Software

"Chris Gorham" wrote in message
...
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