Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear data in a macro
I have a macro that runs and copies data from one set of
cells (ie A1:E1) and pastes it at the bottom of a list (let say its at G20:K20). It does so correctly. Then when I change the data at A1:E1 and run my macro again, it should paste it at G21:K21 but instead it pastes it both at G20:K20 AND G21:K21. Then the next time it does G20:K20 AND G21:K21 AND G22:K22. What statement do I need to put in to stop this from happening? Thanks, Sharon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a macro to clear data from a section? | Excel Discussion (Misc queries) | |||
clear cells macro | Excel Discussion (Misc queries) | |||
macro to clear cells | Excel Discussion (Misc queries) | |||
Clear Contents Macro | Excel Worksheet Functions | |||
macro to clear rows | Excel Programming |