Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a macro to clear data from a section? bwerner53 Excel Discussion (Misc queries) 1 November 1st 09 05:35 PM
clear cells macro Dorothy Excel Discussion (Misc queries) 5 April 7th 08 12:46 AM
macro to clear cells press313 Excel Discussion (Misc queries) 0 May 24th 06 02:31 AM
Clear Contents Macro SJC Excel Worksheet Functions 3 October 27th 05 07:26 PM
macro to clear rows Peter H Excel Programming 6 July 23rd 03 08:50 PM


All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"