Moving from Excel 97 to 2000

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?