Programming Excel with VBA: How to make Selection Nothing

[John Sherry]

Hi
I'm programming Excel in VBA, after running a PasteSpecial method the pasted
region is selected, I do not want any range selected. How can I turn off the
selection?

Anyone got any ideas on how to do this neatly?

Many thanks in advance

[Tom Ogilvy]

Range("A1").Select

or

Selection(1).Select

--
Regards,
Tom Ogilvy


"John Sherry" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I'm programming Excel in VBA, after running a PasteSpecial method the
pasted
> region is selected, I do not want any range selected. How can I turn off
the
> selection?
>
> Anyone got any ideas on how to do this neatly?
>
> Many thanks in advance

[Gary''s Student]

close the file
--
Gary''s Student


"John Sherry" wrote:

> Hi
> I'm programming Excel in VBA, after running a PasteSpecial method the pasted
> region is selected, I do not want any range selected. How can I turn off the
> selection?
>
> Anyone got any ideas on how to do this neatly?
>
> Many thanks in advance

[John Sherry]

Thanks Tom,
Range(A1").Select leaves "A1" selected.

Selection(1).Select leaves top left cell of range selected.

Tried Selection(0).Select, it leaves cell to left of top left cell of range
selected.

Am I asking too much of Excel to expect that there can be no cell selected?

Best regards

"Tom Ogilvy" wrote:

> Range("A1").Select
>
> or
>
> Selection(1).Select
>
> --
> Regards,
> Tom Ogilvy
>
>
> "John Sherry" <[email protected]> wrote in message
> news:[email protected]...
> > Hi
> > I'm programming Excel in VBA, after running a PasteSpecial method the
> pasted
> > region is selected, I do not want any range selected. How can I turn off
> the
> > selection?
> >
> > Anyone got any ideas on how to do this neatly?
> >
> > Many thanks in advance
>
>
>

[Tom Ogilvy]

There will always be something selected unless you protect the sheet and set
enable selection to disallow selection. You can position the cursor off
the screen

ActiveWindow.VisibleRange.Offset(200,0).Activate

perhaps.

When you complained about pastespecial residue, I didn't realize your
request was so primal.

--
Regards,
Tom Ogilvy



"John Sherry" <[email protected]> wrote in message
news:[email protected]...
> Thanks Tom,
> Range(A1").Select leaves "A1" selected.
>
> Selection(1).Select leaves top left cell of range selected.
>
> Tried Selection(0).Select, it leaves cell to left of top left cell of
range
> selected.
>
> Am I asking too much of Excel to expect that there can be no cell
selected?
>
> Best regards
>
> "Tom Ogilvy" wrote:
>
> > Range("A1").Select
> >
> > or
> >
> > Selection(1).Select
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "John Sherry" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi
> > > I'm programming Excel in VBA, after running a PasteSpecial method the
> > pasted
> > > region is selected, I do not want any range selected. How can I turn
off
> > the
> > > selection?
> > >
> > > Anyone got any ideas on how to do this neatly?
> > >
> > > Many thanks in advance
> >
> >
> >

[Dana DeLouis]

Perhaps a workaround...

With ActiveSheet
.EnableSelection = xlNoSelection
.Protect
End With

HTH. :>)
--
Dana DeLouis
Win XP & Office 2003


"John Sherry" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I'm programming Excel in VBA, after running a PasteSpecial method the
> pasted
> region is selected, I do not want any range selected. How can I turn off
> the
> selection?
>
> Anyone got any ideas on how to do this neatly?
>
> Many thanks in advance

[Tushar Mehta]

The only way that I know of not selecting anything is to deselect a
chart. So, if you have a chart in the worksheet, the following in the
VBE Immediate window yields 'Nothing'

activesheet.chartobjects(1).activate
activechart.Deselect
?typename(selection)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> Hi
> I'm programming Excel in VBA, after running a PasteSpecial method the pasted
> region is selected, I do not want any range selected. How can I turn off the
> selection?
>
> Anyone got any ideas on how to do this neatly?
>
> Many thanks in advance
>