Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste special macro stops working when run a 2nd time
I have a strange one where a macro that has been in use for about a year now
which takes information from Clipboard and paste special it into Excel 2003 has suddenly stopped working. The first time you run the macro it does as expected and paste the information and formats it etc. The second time you run it there is truncation occuring in some of the cells. If you close Excel down and reopen and run the macro again with same information it clipboard it runs successfully. Currently running out of idea's so if anybody has and solutions. -- GHumes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste special macro stops working when run a 2nd time
Poste the code and I am sure somebody will tell you what the problem is.
RBS "GHumes" wrote in message ... I have a strange one where a macro that has been in use for about a year now which takes information from Clipboard and paste special it into Excel 2003 has suddenly stopped working. The first time you run the macro it does as expected and paste the information and formats it etc. The second time you run it there is truncation occuring in some of the cells. If you close Excel down and reopen and run the macro again with same information it clipboard it runs successfully. Currently running out of idea's so if anybody has and solutions. -- GHumes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special not working | Excel Worksheet Functions | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
Paste Special not working right | Excel Discussion (Misc queries) | |||
Paste Special Not Working | Excel Worksheet Functions | |||
Macro autocode is not working after special paste. Why ?? | Excel Programming |