Replace cell reference with value

[richard_brussels]

Hi,

I have inherited a rather large worksheet that contains multiple columns of the style:
AC1=($B$1-Q1)/($B$11-1)
AC2=($B$1-Q2)/($B$11-1)
AD1=($B$1-R1)/($B$11-2)

where Q1,R1 etc. are static values.
I would therefore like to replace the references to these cells with the values contained in them so that the cells can then be deleted.
The absolute references MUST be kept as these will be changed.

I'm happy to use a solution within excel or VBA, whatever is best.

Thanks in advance,

 

[richard_brussels]

Hi again,

Problem solved - not the nicest or quickest solution - but it works!
Thanks for reading,

 

[dave3009]

Hi

One solution might have been taking advantage of Find/Replace. Highlight your range press ctrl+h to bring up the dialogue box then Find - Q1 replace - 3 (for example) press Replace all. I would hasten to add I personally would Use find all then replace individually incase of any stray incidences of Q1.

Best Wishes


Dave