The GOTO Special tools (see http://www.auditexcel.co.za/othertools.html to
see how it works) has an option to choose the visible cells only in an area.
You should then be able to delete them. If I have misunderstood the question
please rephrase.

"NoelH" wrote:

Hi
I have created a subtotal for a sheet, is it now possible to delete the
contents of the visble cell (s) in a column, on the visable cells only?

Thanks in advance for any help

Regards Noel