Sorry... no Google results!
 

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

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

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

Sorry... no Google results!
 

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

Sorry... no Google results!
 

http://groups.google.co.uk/groups?q=...tart=10& sa=N

All one line

--
Regards,
Tom Ogilvy


"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

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