View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Sorry... no Google results!

SMS,

If by "delete" you mean clear then something like this:
Selection.SpecialCells(xlCellTypeVisible).ClearCon tents

If you want to delete the entire row that contains the visible cell then
something like this:
Selection.SpecialCells(xlCellTypeVisible).EntireRo w.Delete

hth,

Doug

"rci" wrote in message
...
Hi all...
I've Googled this to death... and found no prior answers to this one...

for multiple selected cells (a selection)... and I want to only delete

the
visible cells in that selection... how?

Thx,

SMS