paste special macro stops working when run a 2nd time

G

GHumes

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.
 
R

RB Smissaert

Poste the code and I am sure somebody will tell you what the problem is.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top