Prev: Hyperlink Function
Next: open several workbooks at the same time
From: GHumes on 5 Jun 2010 10:40
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
From: RB Smissaert on 5 Jun 2010 11:16
Poste the code and I am sure somebody will tell you what the problem is.

RBS


"GHumes" <GHumes(a)discussions.microsoft.com> wrote in message
news:C9EC6FD5-1AD4-4DA5-8B2D-0A7E2106796E(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Hyperlink Function
Next: open several workbooks at the same time