Hello Tom,

Thank you very much for your help. I shall try to answer you
questions as best I can. The word "Total" appears as a result of
formula. It will appear in any column in row 4 on the sheet dependin
on the data. The data will change from day to day so the word "Total
will appear in a different column each day but always in row 4. (doe
this make sense?) I then would like to copy just the selected chunck o
rows 6-30 of the column where the word "Total" appears.

I appreciate your help very much. Looking at the piece of code offere
to me, it all makes sense. It is just that initial step that totall
freezes me

--
oakma
-----------------------------------------------------------------------
oakman's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=27281