View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Copy PasteSpecial not working

Richard,

Have you checked for MISSING references in the VBIDE (ToolsReferences)?
Clear down any you find.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Richard Buttrey" wrote in
message ...
Dave,

Thanks for the prompt response.

It doesn't appear to be a memory problem. I've temporarily changed the
copied range to be a single cell and it's still falling over at the
same PasteSpecial Values code.

ISTR that a few years ago I had a similar problem with a PasteSpecial
Column widths, and the solution was to use a constant. Something like
PasteSpecial:=8 - or similar.

Do you happen to knwo fo there's a similar constant for the Values
option?

Rgds



On Thu, 10 Aug 2006 16:08:45 -0600, "Dave"
wrote:

Richard

Maybe a memory issue. Do you have less RAM on one computer? Maybe try
breaking the named range into two parts and try the paste special with a
smaller range.

Dave

"Richard Buttrey" wrote in
message ...
I've just written a new Excel application which works fine when run on
my local PC, and also when I save a copy on a central network server,
and run it over the network.

However when another user who's testing it, runs it from the same
network server, or on his local PC, the code trips out at the
following line of code:

Range("A1").PasteSpecial (xlPasteValues)

this follows an earlier line where I have copied a named range, i.e.

Range("template").Copy


As far as I can tell we both have the same version of Excel, viz:
2002 SP3.

What's more puzzling is that there are several other applications on
the server with similar Copy Pastespecial instructions, which work
perfectly as expected.

Can anyone suggest what might be causing this problem?

Usual TIA



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________