How do I convert a formula in a cell from "$A$3" to "A3"

[PingPing]

When I run the following code:

Please Login or Register  to view this content.

column C in the active worksheet contains the formulas "=$D$21", "=$D$22", "=$D$23", etc.
However, I want them to contain the formulas "=D21", "=D22", "=D23", etc.

How do I do this in the above VBA code? ie. How do I get rid of the annoying '$'s using VBA?

[Richard Schollar]

You could just use:

Please Login or Register  to view this content.

which will apply the lot in one go.

Richard

[PingPing]

Thank you. That's exactly what I needed.