An Interesting vba Excel quirk
Just to add, I'm surprised that you could refer to the code in the worksheet's
module by using the worksheet (even as an object).
I thought that I'd have to use the .codename to get there.
I learned something today (again!).
Dave Peterson wrote:
I understand the theory, well, after the fact.
I just didn't think it would have worked <bg.
JE McGimpsey wrote:
In article ,
Dave Peterson wrote:
I was surprised that JE's suggestion worked--I wouldn't have guessed that it
would. (Thanks JE for the suggestion.)
Late vs Early binding.
And as I wrote, I agree that the better option is using the CodeName.
--
Dave Peterson
--
Dave Peterson
|