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

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

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

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

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

--
Rick (MVP - Excel)


"ORLANDO VAZQUEZ" wrote in
message ...
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

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

Works great. Thank you!

--
Orlando Vazquez


"Rick Rothstein" wrote:

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

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

--
Rick (MVP - Excel)


"ORLANDO VAZQUEZ" wrote in
message ...
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

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

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

--
Orlando Vazquez


"Rick Rothstein" wrote:

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

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

--
Rick (MVP - Excel)


"ORLANDO VAZQUEZ" wrote in
message ...
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

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

Check your other post, too.

ORLANDO VAZQUEZ wrote:

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

--

Dave Peterson

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

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.

--
Rick (MVP - Excel)


"ORLANDO VAZQUEZ" wrote in
message ...
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

--
Orlando Vazquez


"Rick Rothstein" wrote:

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

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

--
Rick (MVP - Excel)


"ORLANDO VAZQUEZ" wrote in
message ...
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