VBA Code to jump to cell using cell contents

[bobbyphinton]

I am using Excel 2007 and need the code that will take a calculated value from cell A6 and use it in a "Go To" operation. For example, the calculated value in cell A6 is E222. I need code that will recalculate A6 and then go to cell E222.

Thanks in advance....
bobby

 

[Scott Huish]

Hi, welcome to the board!

Is this what you need?

Range(Range("A6")).Select

 

[bobbyphinton]

Scott,
That is exactly what I need.
Thanks for your help,
Bobby