Results 1 to 3 of 3
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: macro issue (2000, 2003)

    You did not provide the macro for us to review.

    Steve

  2. #2
    New Lounger
    Join Date
    Apr 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    macro issue (2000, 2003)

    Edited by HansV to remove attachment with possibly sensitive information

    i record a macro that is supposed to sort ascending, and format a column (center in col, change font, size, underline) and do it relatively. When I run the same macro on another column, all I get is the cell color and font changes, no sort. In 2000, it sorts 4 columns away and I have to edit the macro, in 2003, there is no offset in the macro edit to change. Not sure what is going on.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: macro issue (2000, 2003)

    When one records a macro, certain things, sich as cell addresses and ranges, may be hardcoded.
    You likely need to change the macro to make it more general.

Posting Permissions

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