Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste from clipboard after delete cells
Hi,
I am writing a macro in Excel 2000 Cells.Select Selection.Copy 'then move to another sheet in another workbook. Sheets(currentsheeti).Select 'delete all cell data in the sheet Cells.Delete 'copy from the clipboard starting at cell A1 Range("A1").Select ActiveSheet.Paste Problem : the cells.delete statement clears out the clipboard and so the activesheet.paste command does not work. How can delete then still paste the clipboard. Due to order of events it would be difficult to first delete then copy to clipboard, then paste. Please advise. Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste from clipboard only | Excel Worksheet Functions | |||
Paste clipboard to a comment | Excel Programming | |||
Store clipboard before "vba do cut&paste" then recover stored information to clipboard? | Excel Programming | |||
Paste, clipboard | Excel Programming | |||
paste special whatever is on the clipboard | Excel Programming |