I've been giving "real" codenames to the sheets in my workbooks, making it easier and clearer to refer to them in VBA code. For example, if I have a sheet named "Raw Data", I will change the codename from Sheet1 (or whatever) to "RawDataSheet". Then I can write VBA code like:
My problem: What if I start dealing with multiple open workbooks, where I have to start using ActiveWorkbook or ThisWorkbook in the code? I can refer to this sheet as:Please Login or Register to view this content.
But what if I want to use the codename? Would it be:Please Login or Register to view this content.
How do I qualify a sheet's codename for a particular workbook?Please Login or Register to view this content.
Thanks...
Bookmarks