• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
  • 6
  • 3
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
use this command

range("A35").select
0
 
Rob HensonIT & Database AssistantCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now