Actually, I've just discovered a problem with the solution provided. due
to my not supplying sufficient info.
My data to be deleted resides in say B4:X10, (always these columns,
but last row varies between 6 and 16).
I also have some formulae in Z4:Z10 that I don't want deleted.
The solution from JE McGimpsey unfortunately deletes these formulae.
RichT Wrote:
Many thanks for this.
It works well.
I don't really get what the following line does:-
nRows = Application.Min(18, .End(xlDown).Row) - 3
but no worries, I'm just happy it works.
Thanks again,
Richard.
--
RichT
------------------------------------------------------------------------
RichT's Profile:
http://www.excelforum.com/member.php...o&userid=23678
View this thread:
http://www.excelforum.com/showthread...hreadid=380548