Thread: Goto Reference:="abc" where abc is formula result
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ORLANDO VAZQUEZ[_2_] ORLANDO VAZQUEZ[_2_] is offline
external usenet poster
  
Posts: 43
Default 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


Reply With QuoteReply With Quote