Jump to content

Recommended Posts

Posted

I've recorded a macro for sorting a column in Excel in Office xp. When I run the macro on a machine with Office 2000 it throws up an error message for the 1st line - Range("ai3:ak15").Select

I dont much about macro programming and so am a bit stuck.

The macro code is

Range("ai3:ak15").Select
Selection.Sort Key1:=Range("ai3"), Order1:=xlAscending, Header:=xlNo _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Any help appreciated. Thanks.


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...