Hello,
Can somebody find the problem for me. In the commandbutton feature I'm getting an error at the end when I want to end up Selecting a single cell.
Thanks for the help.Please Login or Register to view this content.
Hello,
Can somebody find the problem for me. In the commandbutton feature I'm getting an error at the end when I want to end up Selecting a single cell.
Thanks for the help.Please Login or Register to view this content.
I ran your code and it was executed without any problem. It selected A2 in the end.
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.
hi trevor2524,
What is error you are getting? see the attached its working for me.
Regards,
Joshi
Cheers,
Joshi
Being with a winner makes you a winner
When I run it from a commandbutton I get the follow error: Select Method of Range class failed. Is there another way I should do this so I can make the entire sheet yellow and end by selecting A2?
It will throw that error if your command button is not on Sheet1 as per your code. If this is the case, try something like this.......
Please Login or Register to view this content.
Thank You!
Did it work?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks