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
__________________________
|