paste special macro stops working when run a 2nd time

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

 

[RB Smissaert]

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

RBS