A little macro help

Experts,
Need a macro for a command button that takes me from the command button to specific cell on spreadsheet: For example, I need to goto cell A35 when I click the command button
Frank FreeseAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
use this command

range("A35").select
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Sub Navigate()
  Range("A35").Select
End Sub

or

Sub Navigate()
  Application.GotoReference("A35")
End Sub

If your destination had a Defined Range Name, dynamic or static, you can replace the A35 with the range name. This would overcome the issue of it being on another sheet, otherwise you could include the following in either:

Sheets("Sheet1").Select

Unless you actually want the cell to become the Active Cell, its not normally necessary to Select the cell to gain information from it for further processing in the macro. Some more detail of the scenario and we might be able to help further.

Thanks
Rob H
0
 
Frank FreeseAuthor Commented:
Perfect
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Frank FreeseAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for fh_freese's comment http:/Q_27402658.html#36987442
Assisted answer: 250 points for ssaqibh's comment http:/Q_27402658.html#36987080
Assisted answer: 250 points for robhenson's comment http:/Q_27402658.html#36987101

for the following reason:

thank you
0
 
Frank FreeseAuthor Commented:
woops - did not mean to accept myself...
0
 
Frank FreeseAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for fh_freese's comment http:/Q_27402658.html#36987459
Assisted answer: 250 points for ssaqibh's comment http:/Q_27402658.html#36987080
Assisted answer: 250 points for robhenson's comment http:/Q_27402658.html#36987101

for the following reason:

thank you
0
 
Frank FreeseAuthor Commented:
folks...I want to distribute points but have made a mistake...how can I fix that?
0
 
Saqib Husain, SyedEngineerCommented:
"Accept multiple" again and do not select your comment
0
 
Frank FreeseAuthor Commented:
ok...please make sure you get your points. thank you
0
 
Saqib Husain, SyedEngineerCommented:
Try again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.