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