select non-locked cells

[kontraa]

...it is possible to select only cells which are not locked...
or delete...

thanx a lot

[Tom Ogilvy]

Sub SelectnonLocked()
Dim cell as Range, rng as Range

for each cell in ActiveSheet.usedRange
if cell.locked = False then
if rng is nothing then
set rng = cell
else
set rng = union(rng,cell)
end if
end if
Next
If not rng is nothing then
rng.select
end if
end sub

--
Regards,
Tom Ogilvy


"kontraa" wrote:

>
> ...it is possible to select only cells which are not locked...
> or delete...
>
> thanx a lot
>
>
> --
> kontraa
> ------------------------------------------------------------------------
> kontraa's Profile: http://www.excelforum.com/member.php...o&userid=33028
> View this thread: http://www.excelforum.com/showthread...hreadid=537177
>
>

[Browner]

Is there a way to select and ONLY paste the cells that are visable...

meaning if you have either Hidden or perhaps cells that are collapsed into Hierachy's and you only want to copy and paste the cells "as you see them"

How do you do that? Thanks,

[Tom Ogilvy]

copy and paste. That is the default behavior.

--
Regards,
Tom Ogilvy


"Browner" wrote:

>
> Is there a way to select and ONLY paste the cells that are visable...
>
> meaning if you have either Hidden or perhaps cells that are collapsed
> into Hierachy's and you only want to copy and paste the cells "as you
> see them"
>
> How do you do that? Thanks,
>
>
> --
> Browner
> ------------------------------------------------------------------------
> Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
> View this thread: http://www.excelforum.com/showthread...hreadid=537177
>
>

[Browner]

Wow you truly are a knowlegable force within MS Excel...

Perhaps i phrased the question incorrectly. I was looking for a way to ONLY Paste what i saw... when in fact copy and paste will paste what is shown... it actually pastes all other hidden and supressed cells as well.

The good thing is i found the answer... no thanks to you.
You must hit Control G and go to view on only visable cells then hit control c and paste that.

Jerk!

[Tom Ogilvy]

Hope your day impoves.

--
Regards,
Tom Ogilvy


"Browner" wrote:

>
> Wow you truly are a knowlegable force within MS Excel...
>
> Perhaps i phrased the question incorrectly. I was looking for a way to
> ONLY Paste what i saw... when in fact copy and paste will paste what is
> shown... it actually pastes all other hidden and supressed cells as
> well.
>
> The good thing is i found the answer... no thanks to you.
> You must hit Control G and go to view on only visable cells then hit
> control c and paste that.
>
> Jerk!
>
>
> --
> Browner
> ------------------------------------------------------------------------
> Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
> View this thread: http://www.excelforum.com/showthread...hreadid=537177
>
>

[Dave Peterson]

""Oh, uh, there won't be any money, but when you die, on your deathbed, you will
receive total consciousness." So I (YOU) got that goin' for me, which is nice."

http://www.imdb.com/title/tt0080487/quotes



Tom Ogilvy wrote:
>
> Hope your day impoves.
>
> --
> Regards,
> Tom Ogilvy
>
> "Browner" wrote:
>
> >
> > Wow you truly are a knowlegable force within MS Excel...
> >
> > Perhaps i phrased the question incorrectly. I was looking for a way to
> > ONLY Paste what i saw... when in fact copy and paste will paste what is
> > shown... it actually pastes all other hidden and supressed cells as
> > well.
> >
> > The good thing is i found the answer... no thanks to you.
> > You must hit Control G and go to view on only visable cells then hit
> > control c and paste that.
> >
> > Jerk!
> >
> >
> > --
> > Browner
> > ------------------------------------------------------------------------
> > Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
> > View this thread: http://www.excelforum.com/showthread...hreadid=537177
> >
> >

--

Dave Peterson

[Tom Ogilvy]

Ah, it is nice when you say it that way. <g>

--
Regards,
Tom Ogilvy

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44527C33.EA6C459@verizonXSPAM.net...
> ""Oh, uh, there won't be any money, but when you die, on your deathbed,
you will
> receive total consciousness." So I (YOU) got that goin' for me, which is
nice."
>
> http://www.imdb.com/title/tt0080487/quotes
>
>
>
> Tom Ogilvy wrote:
> >
> > Hope your day impoves.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Browner" wrote:
> >
> > >
> > > Wow you truly are a knowlegable force within MS Excel...
> > >
> > > Perhaps i phrased the question incorrectly. I was looking for a way to
> > > ONLY Paste what i saw... when in fact copy and paste will paste what
is
> > > shown... it actually pastes all other hidden and supressed cells as
> > > well.
> > >
> > > The good thing is i found the answer... no thanks to you.
> > > You must hit Control G and go to view on only visable cells then hit
> > > control c and paste that.
> > >
> > > Jerk!
> > >
> > >
> > > --
> > > Browner
> >
> ------------------------------------------------------------------------
> > > Browner's Profile:
http://www.excelforum.com/member.php...o&userid=33657
> > > View this thread:
http://www.excelforum.com/showthread...hreadid=537177
> > >
> > >
>
> --
>
> Dave Peterson