Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
Mult formula cell displays "0", which formula created result? | Excel Worksheet Functions | |||
Application.Goto Reference:="ActiveCell.Value"??? Whats wrong?? | Excel Programming | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Application.Goto reference:="MyCell" | Excel Programming |