Hi
I have a range in an excel sheet.
The row is always of a single column, but multiple rows
How can I get all the elements of the Range into a Collection
The Range can be continous like
Range("A1:A15").Select
or it can be discontinous like
Range("A1,A5,A10,A14,A17").Select
How can I get all the elements of that Range into a collection . I prefer to get the row numbers of the range into the collection
Please suggest
Thanks
I have a range in an excel sheet.
The row is always of a single column, but multiple rows
How can I get all the elements of the Range into a Collection
The Range can be continous like
Range("A1:A15").Select
or it can be discontinous like
Range("A1,A5,A10,A14,A17").Select
How can I get all the elements of that Range into a collection . I prefer to get the row numbers of the range into the collection
Please suggest
Thanks