Excel - Problem running macro in new version

T

TC

Ever since I had newer version of Excel installed I can’t run macro
which was executing perfectly before an update.
Excel version: 2003 SP2
VB version: 6.3 9972

Below is the code, which always shows as a stopper ….

Workbooks("SummaryMaster2").Activate
Workbooks("SummaryMaster2").Sheets("Main").Select

And the error message is
“Run-time error ‘9’
Subscript out of rangeâ€


Any help will be greatly appreciated.

TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro won't run in the newer version 4
Excel 2007 creates a circular reference 0
Macro opens files as it tries to access them !!! 2
Excel crashes when running a Macro 0
Running a macro in Excel 1
Pivot Table Macro Run-time error 3
Excel 2007: Creating a macro that will run Solver. 0
Protect Workbook Code Queres 2

Top