View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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