I cannot figure out a portion of my macro. What I would like to happen is to have a macro goto a certain cell in column A, based on the value of B1.
Example: if B1 = 1, goto A1. If B1 =2, goto A2. If B1 = 3, goto A3. And so forth.
Any suggestions?
Thanks in advanced!!!
Try this.....
Is this what you are trying to achieve?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
A couple of ways:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes, it worked perfect! Thank you so much, sktneer & TMSOriginally Posted by sktneer
You're welcome.
You're welcome. Glad I could help.
To be more on the safer side, you may also try this......
You may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.Please Login or Register to view this content.
Ah, I see. Will do
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks