| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dragging formula to make selection | Excel Discussion (Misc queries) | |||
| How can I make random selection from excel list? | Excel Discussion (Misc queries) | |||
| how to make a menu selection in the same cell? | Excel Discussion (Misc queries) | |||
| how make a selection like sum function's | Excel Programming | |||
| Programming to make graph work. | Excel Programming | |||
Linear Mode
