Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everybody,
this is part of my code: .... ...... With Worksheets("Sheet1").Cells .Copy .PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End With ...... .... the code copies all cells of an (inactive) worksheet and pastes the values back onto the worksheet, so that there are no formulas left anymore. When I return to that particular sheet, I can still see that all the cells are selected. How can I get rid of the selection? I want the selected cell to be A1, but adding code for selecting cell A1 did not help. Please help. Regards, Norbert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting a Selection as a Picture | Links and Linking in Excel | |||
Pasting Selection In First Blank Row | Excel Discussion (Misc queries) | |||
pasting formulas into a selection | Excel Worksheet Functions | |||
pasting formulas into a selection | Excel Programming | |||
pasting selection to end of workbook? | Excel Programming |