Hi,
I am currently calling a method written in a class in
VB 6.0. This method of
the class is called on the form. The method takes a Range (i.e. Excel range
as a parameter). The method is not allowed to except more than this as a
parameter.
Now inside the range passed as a parameter there may or may not be a group
of cells (which themselves are part of a named range (this named range would
always start with letter TG_ but remaining part of the name is not known
I want the piece of code to be written inside this method in class so that
with the given range as parameter, I can scan it and find the cells which
belong to range starting with name as TG_
I am using
VB 6.0 with Excel 2000.
Please do let me know if I can provide further inputs.
Thanks