IT Employment

Ask something
Discussion Locked

Moving from Excel 97 to 2000

0 helpful
1 reply

by aj.cross

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Having just upgraded from Excel 97 under Windows 95 to Excel 2000 under Windows XP, I now find that some of my VBA macros are failing.
They all fail when requesting a range reference by name in the code e.g.
Range("StrName").Select.
Has anyone else experienced this and if so, what was the fix?

1 reply

by aj.cross

Further tinkering has revealed that the only Sub procedures that are failing are those called from a workbook property, e.g.
Workbook_Open()

When modified to call all Sub procedures from a button or other direct method, no problems are experienced - weird!!

This discussion is closed to new replies.