+ Reply to Thread
Results 1 to 4 of 4

Macro created in excel 2010 and compatible with excel 2003.

  1. #1
    Registered User
    Join Date
    01-02-2011
    Location
    Miami, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Macro created in excel 2010 and compatible with excel 2003.

    Good Day,

    I have this macro for switching sheets. But if the worksheet is run on excel 2003 an error occurred.

    Sub Job_1()
    ThisWorkbook.Sheets("JOB DESCRIPTION").Activate
    Sheets("JOB DESCRIPTION").Range("A22").Select
    End Sub

    Is there any macro similar to this that is compatible with 2003?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,597

    Re: Macro created in excel 2010 and compatible with excel 2003.

    There's nothing in that code that wouldn't work in Excel 2003.

    Mind you using Activate and Select probably isn't needed.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,180

    Re: Macro created in excel 2010 and compatible with excel 2003.

    That is compatible with 2003, I suspect your problem lies elsewhere

  4. #4
    Registered User
    Join Date
    04-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Macro created in excel 2010 and compatible with excel 2003.

    What error do you get?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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