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