Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Goto a referenced cell

Is there a way to go to a cell address written in another cell.
Example: In cell E13 I have the text "H12". I want the macro to look at
cell E13, read the value H12 and goto cell H12. Thanks for your help in
advance.

Michael

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Goto a referenced cell

Hi

Try this

Dim var As String
var = Range("E13").Value
Application.Goto Range(var)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"mburkett" wrote in message oups.com...
Is there a way to go to a cell address written in another cell.
Example: In cell E13 I have the text "H12". I want the macro to look at
cell E13, read the value H12 and goto cell H12. Thanks for your help in
advance.

Michael



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
bold text of referenced cell show in formula cell zabcikranch Excel Worksheet Functions 1 February 2nd 10 07:42 PM
Return Results of a cell based on cell referenced in a cell Drew Excel Worksheet Functions 4 September 3rd 09 06:19 PM
Change Text Color in one cell based upon entry in referenced cell Tee Excel Discussion (Misc queries) 3 September 12th 08 10:07 PM
HOW IS COLUMN "K" REFERENCED ON THE CURRENT ROW IN THE GOTO COMMAN mbnspect Excel Discussion (Misc queries) 5 January 10th 08 11:50 PM
goto a particular cell Newbie Excel Programming 5 April 15th 04 01:46 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"