Runtime 1004 Sort method of range
 

I am trying to troubleshoot a vba script that was written for one of our
departments (the person who wrote it is no longer with our company).
Basically, it's a macro in Excel that gets data from other sources (ex.
databases or other network drives) and populates a new worksheet in
Excel. The problem is that it works fine on one computer but doesn't
work on 3 other computers. The error we get is "Runtime 10004 Sort
method of range". All computers are running Windows XP but the one
that runs the program fine is not on any service packs. Our IT
administrator does not want to go backwards (in terms of removing
service packs). But not sure if that truly is the problem. I'm no VBA
guru here so I'm hoping someone has clues to what could be going on??


--
crt
------------------------------------------------------------------------
crt's Profile: http://www.excelforum.com/member.php...o&userid=27078
View this thread: http://www.excelforum.com/showthread...hreadid=465968

Runtime 1004 Sort method of range
 

Sometimes, it's as simple as qualifying the ranges.

But it's difficult to guess without at least a snippet of code.

crt wrote:

I am trying to troubleshoot a vba script that was written for one of our
departments (the person who wrote it is no longer with our company).
Basically, it's a macro in Excel that gets data from other sources (ex.
databases or other network drives) and populates a new worksheet in
Excel. The problem is that it works fine on one computer but doesn't
work on 3 other computers. The error we get is "Runtime 10004 Sort
method of range". All computers are running Windows XP but the one
that runs the program fine is not on any service packs. Our IT
administrator does not want to go backwards (in terms of removing
service packs). But not sure if that truly is the problem. I'm no VBA
guru here so I'm hoping someone has clues to what could be going on??

--
crt
------------------------------------------------------------------------
crt's Profile: http://www.excelforum.com/member.php...o&userid=27078
View this thread: http://www.excelforum.com/showthread...hreadid=465968

--

Dave Peterson