+ Reply to Thread
Results 1 to 2 of 2

Run time Error 438 on Sort

  1. #1
    Forum Contributor
    Join Date
    06-18-2015
    Location
    Milton Keynes
    MS-Off Ver
    2016
    Posts
    101

    Run time Error 438 on Sort

    Hi,

    I have a piece of VBA code that is part of a longer code, but when I run it on a colleagues machine I'm getting a runtime 438 error.

    The code is

    Please Login or Register  to view this content.
    And specifically I'm getting the error on the line

    Please Login or Register  to view this content.
    Both machines are running office 365 and I can't find a resolution.

    Any ideas??

  2. #2
    Forum Contributor
    Join Date
    06-18-2015
    Location
    Milton Keynes
    MS-Off Ver
    2016
    Posts
    101

    Re: Run time Error 438 on Sort

    Sorry should add that this code is just to sort some data by 3 columns, Column I ascending followed by B ascending and then D ascending.

    This is so that i can get all like data in order, so I is order or quote (A for order b for quote), b sorts by salesman and D by customer. That way I can make a sequential ID number based on the order type, salesman and customer

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  2. [SOLVED] Run-time error when trying to sort a range
    By g8r777 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 06:08 PM
  3. Sort: Run-time error '1004'
    By nbuk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2010, 12:20 PM
  4. VBA Sort 1004 Run-time error
    By Code Flunkie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2010, 03:13 PM
  5. Sort VBA Run Time Error 438
    By XM5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2009, 01:24 AM
  6. [SOLVED] Run-time error 1004 with sort
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2005, 08:05 PM
  7. [SOLVED] RE: Run-time error 1004 with sort
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1