Change all of the relative references to absolute in an entire worksheet

[Liz Smart]

Hi there...

Hoping someone can help me out.

I have a large selection of cells that have lengthy formulas and I am looking for a way to select the entire group of cells and change all of the relative references within the formulas to absolute references.

Ultimately, I want to copy this section of cells below the original cells on the same worksheet and not change the formulas (I will do use the Replace function to change 1 variable after copying). I can't use "replace" to change the formulas, because there are so many different variables, it would take me all day.

Thanks! Liz

[shg]

Why? ... Pad ...

[Liz Smart]

What does Why? Pad mean?

[shg]

The forum requires 10 characters in posts. I just wanted to know why you want to do this.

[Paul]

Hi Liz, welcome to the forum!

You might want to look into the Application.ConvertFormula method. I've provided an example below, which will convert all cell references in A1:A3 to absolute:

Please Login or Register  to view this content.

Hopefully that helps you out!