Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to create a macro that puts the cursor over a cell which is retrieved from the cell it's standing on. Wow, I notice english is not my first language, because even I can't really understand what I just wrote :) An example would be better. Let's say I'm standing on a cell with the formula "=A25". Now when I'm standing on this cell I want to run a macro that moves the cursor over the referenced cell (A25). Now I can go to a cell if I have the position of the cell as text in the current cell as: Range(Activecell.Value).Select How can I achieve this to replace Activecell.value with the text gotten from the formula? TIA Regards, -- Beto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
The result of a formula referring to a cell with formula as text? | Excel Worksheet Functions | |||
Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions |