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

yep, but might be open to offers :) ... glad to assist

--
Cheers
JulieD

"rci" wrote in message
...

Wow... you guys are awesome... Julie, you anticipated that I really meant
clear contents... this works perfect!

Are you married?

:-)



JulieD wrote:
: 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