Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro Error

Status
Not open for further replies.

markmu

Instructor
Sep 13, 2000
3
US
I have an excel workbook created in office 95 that has a macro when run copies a master worksheet based on another worksheet data range. Everything works great in 95. If I try to run the same macro in any other version it errors out on the last couple of sheets. Was there a change in the visual basic modules from 95 and later that keeps the macro from executing. Any guidance is greatly appreciated.

Mark
 
I've run into the same thing with macros that work on Office 2000 but not Office 97. Had to re-create the macros in 97....I'm not a code guy . . . .YET!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top