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?
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.
That is compatible with 2003, I suspect your problem lies elsewhere
What error do you get?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks