View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Sorry... no Google results!

Hi rci

do you mean "delete" or "clear contents" ... for clear contents the code
would be
----
Selection.SpecialCells(xlCellTypeVisible).ClearCon tents
-----

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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