Sorry... no Google results!

[rci]

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

[JulieD]

Hi rci

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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"rci" <[email protected]> wrote in message
news:[email protected]...
> 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

[Doug Glancy]

SMS,

If by "delete" you mean clear then something like this:
Selection.SpecialCells(xlCellTypeVisible).ClearContents

If you want to delete the entire row that contains the visible cell then
something like this:
Selection.SpecialCells(xlCellTypeVisible).EntireRow.Delete

hth,

Doug

"rci" <[email protected]> wrote in message
news:[email protected]...
> 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

[rci]

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

Are you married?

:-)



JulieD <[email protected]> wrote:
: Hi rci

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

: --
: Cheers
: JulieD
: check out www.hcts.net.au/tipsandtricks.htm
: ...well i'm working on it anyway
: "rci" <[email protected]> wrote in message
: news:[email protected]...
:> 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

[Tom Ogilvy]

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

All one line

--
Regards,
Tom Ogilvy


"rci" <[email protected]> wrote in message
news:[email protected]...
> 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

[JulieD]

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

--
Cheers
JulieD

"rci" <[email protected]> wrote in message
news:[email protected]...
>
> Wow... you guys are awesome... Julie, you anticipated that I really meant
> clear contents... this works perfect!
>
> Are you married?
>
> :-)
>
>
>
> JulieD <[email protected]> wrote:
> : Hi rci
>
> : do you mean "delete" or "clear contents" ... for clear contents the code
> : would be
> : ----
> : Selection.SpecialCells(xlCellTypeVisible).ClearContents
> : -----
>
> : --
> : Cheers
> : JulieD
> : check out www.hcts.net.au/tipsandtricks.htm
> : ...well i'm working on it anyway
> : "rci" <[email protected]> wrote in message
> : news:[email protected]...
> :> 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
>
>