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
|