In .NET, you can turn Option Strict off and a collection's data type will be implicitly defined, so if I input a set of ranges as the collection items, they will come out as ranges, but I am having a problem with VBA, I am making a collection of cells in a range, but when I check the immediate window for the data type, and its Variant. I want to put in ranges and work with those ranges....why is it converting? is there a way for it not to?
Can you post your code?
If posting code please use code tags, see here.
Its an *.xla I have attached it, you have helped me with part of it earlier, I remember the name.
ListComparer3 (2).zip
Which collection do you want to be made up of ranges rather than variants?
I want to use UserRanges as the collection of ranges
Remove the () around rng, they cause rng to be evaluated.
Please Login or Register to view this content.
really?!? Dunce cap of the year for this kid
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks