Goto Reference:="abc" where abc is formula result

[ORLANDO VAZQUEZ]

Hi!

In this macro ....Application.Goto Reference:="tab abc"
where "tab abc" equals the results of the formula in cell a1 which is
subject to change. I want to goto location specified by the formula in cell
A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto tab "equity1"
If cell A1 formula result = fixed2, then I want to go to tab fixed2...



Thank you.

Orlando

 

[Rick Rothstein]

You should be able to do it this way...

Worksheets(Range("A1").Value).Activate

 

[ORLANDO VAZQUEZ]

Works great. Thank you!

--
Orlando Vazquez

You should be able to do it this way...

Worksheets(Range("A1").Value).Activate

 

[ORLANDO VAZQUEZ]

Rick
Can I ask an auxilliary question:

Can I make this macro more specific, say, go to the row and column in that
specificed in the formula in that cell? (As opposed to just going to the
worksheet)


Thanks.
Orlando

 

[Dave Peterson]

Check your other post, too.

Hi!

In this macro ....Application.Goto Reference:="tab abc"
where "tab abc" equals the results of the formula in cell a1 which is
subject to change. I want to goto location specified by the formula in cell
A1.

For example if cell A1 formula result = equity1
When I run this macro I want to goto tab "equity1"
If cell A1 formula result = fixed2, then I want to go to tab fixed2...

Thank you.

Orlando

 

[Rick Rothstein]

I think you will have to give an example of the formula. My main concern is
if there is more than one cell referenced or if a cell range is referenced;
but I would also like to see the type of formula you are talking about so I
can see where in the formula the cell reference is at.