Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and clear problem
Hi
I am using Excel 97 (VBA)and have a problem. Basically what I want to do is copy two cells, clear the whole sheet and then paste the contents of the cells back onto the sheet. The problem I am having is that as the contents of the cells are derived from a calculation on the sheet, when it attempts to paste the contents back onto the sheet there is nothing to paste (don't know why). I am attempting to do this using a macro. If you understand my problem and think you can help, please post the relevant code. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear and Copy vs Delete | Excel Discussion (Misc queries) | |||
Clear Comment problem | Excel Discussion (Misc queries) | |||
Clear Clipboard after Copy | Excel Discussion (Misc queries) | |||
clear, copy and paste | Excel Programming | |||
Clear destination, then copy betwen workbooks | Excel Programming |