Hi, could you please kindly explain as to why the first line of code works fine and the second one doesn't (Type mismatch- Error13)?
Please note that 'testsheet' is the name I gave to a specific tab (like Sheet1 for example). It must work like that due to the actual visible sheet name potentially changing.
Please Login or Register to view this content.Many thanks!Please Login or Register to view this content.
Last edited by Frenzyy; 05-07-2020 at 08:14 AM.
Is testsheet a variable?
If so how have you declared it & assigned a value to it?
It's not and I haven't, though I have tried.
Just to make sure that we are clear on what I'm trying to refer to with 'testsheet'- think about it as if this was the 'Sheet1' set by default in the background. Hope you understand what I mean.
Thanks!
Do you mean the sheet codename?
Where you have change the word infront of the brackets?
Yes, exactly. Sorry about that, couldn't think of the exact name.
In that case you would useBut this will only work if testsheet is in the same workbook as the code.Please Login or Register to view this content.
Works great, thank you very much.
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks