LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default class module variable declaration issue

Ken,

The biggest difference is that I used a collection, and changed the Let statement to = Value.

And, no, I didn't work on it for 55 minutes ;-) Maybe 5... but I've worked on Excel programming for
nearly 20 years - so that should count for something....

Bernie
MS Excel MVP


"Ken" wrote in message
...
Bernie
I will have to study the differences between yours and mine to figure
out the exact difference, other than the most important difference
which is yours works, mine doesn't. Also, assuming you worked on
yours the entire 55 minutes between the time I posted to your
response, then I probably worked on mine about 10 times longer.
Thanks to all.
Ken





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
Class Module vs Normal Module Les Excel Programming 2 July 20th 07 09:54 AM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM
Pass a variable from a class module pk Excel Programming 1 October 2nd 03 08:24 PM
Variable Declaration?? Tom Ogilvy Excel Programming 1 August 8th 03 06:45 PM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"