I have written a basic code to paste and sort data. It works fine when i write it, though if I close Excel it never works again. Can anyone see why.
Code is designed to paste data copied from a report sorted to be used for a mail merge.
Please Login or Register to view this content.
Hello BarryDragon,
Welcome to the Forum!
- How is the macro run: manually or automatically?
- If automatically then which event calls it?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi, the Macro is run by a button click, I have the data copied already
Hello Barry,
When you click the button, the macro runs then nothing happens on the sheet or does it error?
If you have run the macro on the data then saved it then you wouldn't see anything happen when the macro is run again on the saved data.
the macro produces an error on the first paste function. Seems that the data in the clipboard might be disappearing. Though I do not have a clue why, as i said it works if i make a new spreadsheet and put the code in, and I have another spreadsheet that does something similar (by pasting in data already in clipboard) and works fine.
Where do those to be copied data come from ?
Please Login or Register to view this content.
Last edited by snb; 08-30-2011 at 07:00 AM.
The data is copied from a paypal report in excel.
When I use our code I get an error on the paste function...
if the workbook 'paypaldata' contains those data
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks