Probably the best way to describe this is to do a print screen of
portion of the spreadsheet. In the screen print, I want to know th
range from D1 through D19 Cal_Align_EE.checksum and though you can'
see all of Cal_EE.checksum its range. The number of ranges fro
spreadsheet to spreadsheet can vary from just a few to several dozen.
Note that the names can change from spreadsheet to spreadsheet in th
prefix. The suffix post decimal is always the same (checksum). Th
result I'm searching for would look like below:

A B C
1 Cal_EE_Align.checksum D1 D19

2 Cal_EE.checksum D23 D25
3 Something.checksum D45 D55
4 Somethingagain.checksum D132 D199
5 ..........etc

Remember that the ranges will be different from spreadsheet t
spreadsheet and the names in column A will be different fro
spreadsheet to spreadsheet. The only common thing from checksum grou
to checksum group is the .checksum suffix.

Is this a little clearer. Many thanks if you can assist me on thi
one.

Ton

+-------------------------------------------------------------------
|Filename: PrintScreenOfProblem.gif
|Download: http://www.excelforum.com/attachment.php?postid=3850
+-------------------------------------------------------------------

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=47057