| 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 |
| 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 | |||
![ORLANDO VAZQUEZ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
