In a sheet name "Results" range("A5") I have the value "thisworkbook.sheets("Hold")
I need to reference the sheet in VBA but get the value in range("A5").
Example: some how do this:
This would activate sheets("Hold").
Please Login or Register to view this content.
How can I change this to make it work
Maybe something like...
Please Login or Register to view this content.
HTH
Regards, Jeff
The challenge there is I need to reference that sheet. Like
I need to set Hat equal to the sheet also because after everything is done, I set hat equal toPlease Login or Register to view this content.
Please Login or Register to view this content.
and do it again
I think that you should declare Hat as A Range
Oops - probably a string would be better:|
Last edited by xladept; 03-09-2015 at 06:48 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi Mattress58
Probably something like this...
Nah...that won't work...Please Login or Register to view this content.
Last edited by jaslake; 03-09-2015 at 06:49 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
You probably have to extract the sheet name from the rest of the text, for exampl;e:
Please Login or Register to view this content.
thanks for the help. I got it here.
Please Login or Register to view this content.
Avoid 'select' and 'activate' in VBA
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks