| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Paste Special - replace contents of destination cells
Hi All,
I'm using Paste Special in a Macro to copy the format and column widths etc and overwrite some existing data in the destination cells. Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False I receive an Information Alert message: "Do you want to replace the contents of the destination cells? Yes / No" How can I reply "Yes" to the Alert Message within the Macro to prevent user intervention? Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200604/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Do you want to replace the contents of the destination cells?" | Excel Discussion (Misc queries) | |||
| Do you want to replace the destination cells? | Excel Discussion (Misc queries) | |||
| Paste contents, but keep formula of destination | Excel Discussion (Misc queries) | |||
| Macro causes "Do you want to replace the contents of the destination cells" | Excel Programming | |||
| Replace destination cells | Excel Programming | |||
Threaded Mode
