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