Programming Excel with VBA: How to make Selection Nothing
 

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

Programming Excel with VBA: How to make Selection Nothing
 

Range("A1").Select

or

Selection(1).Select

--
Regards,
Tom Ogilvy


"John Sherry" wrote in message
...
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

Programming Excel with VBA: How to make Selection Nothing
 

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

Programming Excel with VBA: How to make Selection Nothing
 

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" wrote in message
...
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

Programming Excel with VBA: How to make Selection Nothing
 

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" wrote in message
...
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" wrote in message
...
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

Programming Excel with VBA: How to make Selection Nothing
 

Perhaps a workaround...

With ActiveSheet
.EnableSelection = xlNoSelection
.Protect
End With

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


"John Sherry" wrote in message
...
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

Programming Excel with VBA: How to make Selection Nothing
 

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 ,
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

Programming Excel with VBA: How to make Selection Nothing
 

Still around? i don't think anyone answered your question properly.

Application.CutCopyMode = False

This will deselect the region. The advice that there is always something
selected is wrong. There is always something activated (though that chart
thing from Tushar sounds like an exception).


"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

Programming Excel with VBA: How to make Selection Nothing
 

I always select the first cell

For example
http://www.rondebruin.nl/values.htm

..Cells(1).Select

See the first macro


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Allen_N" wrote in message ...
Still around? i don't think anyone answered your question properly.

Application.CutCopyMode = False

This will deselect the region. The advice that there is always something
selected is wrong. There is always something activated (though that chart
thing from Tushar sounds like an exception).


"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