Myrna,
Thanks very much for your solution -- of course, it works.
And thank you so much for presenting it in a very organized and
straight-forward manner.
The key is your formula for "BottomRow"; I changed the reference for
"LeftCol" to a reference for SpecialCol (a column that has a value in
the last row of the SS).
One, probably silly, question: Why is it not necessary to "Dim
TopRow"?
Thanks again,
Chuckles123
--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...o&userid=14948
View this thread:
http://www.excelforum.com/showthread...hreadid=275944