[SOLVED] Urgent Please: PasteSpecial not working. Very wierd

[michael.beckinsale]

Hi All,

Very strange problem.

I am in the middle of developing a workbook which has many paste
special operations carried out using the VBA code below. Over the past
6 weeks or so all the code in all the modules / forms has worked fine
using same code. Now whenever the code reaches this line in any of the
modules / forms it crashes! I have tried re-booting and different
computers but the problem remains. Is there any way that paste special
can be turned of ?

Workbook has been developed to work on XL2000 upwards. I noticed that
recording on XlL2003 produces Paste:=xlPasteValues but changing that
does not make any difference.

All suggestions gratefully received


Selection.PasteSpecial Paste:=xlValues

Regards

Michael Beckinsale

[Don Guillett]

instead of copy/paste loading up the clipboard, try
range("a1:x21").value = range("b1:y21").value
notice the ranges must be the same size

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"michael.beckinsale" <michael.beckinsale@ntlworld.com> wrote in message
news:1153136599.889185.95330@i42g2000cwa.googlegroups.com...
> Hi All,
>
> Very strange problem.
>
> I am in the middle of developing a workbook which has many paste
> special operations carried out using the VBA code below. Over the past
> 6 weeks or so all the code in all the modules / forms has worked fine
> using same code. Now whenever the code reaches this line in any of the
> modules / forms it crashes! I have tried re-booting and different
> computers but the problem remains. Is there any way that paste special
> can be turned of ?
>
> Workbook has been developed to work on XL2000 upwards. I noticed that
> recording on XlL2003 produces Paste:=xlPasteValues but changing that
> does not make any difference.
>
> All suggestions gratefully received
>
>
> Selection.PasteSpecial Paste:=xlValues
>
> Regards
>
> Michael Beckinsale
>

[michael.beckinsale]

Don,

Thanks for your reply.

I dont have the time to replace all the relevant code at the moment.

Is there a way to 'empty' the clipboard via VBA?

Regards

Michael beckinsale