| Home |
| Search |
| Today's Posts |
|
#3
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 |
| 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 | |||
Threaded Mode
