Thread: run time error 1004 naming a sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
  
Posts: 193
Default run time error 1004 naming a sheet
Using Excel 97 on Windows 2000 Pro., the following code runs fine:

sheets(1).name = "Data"

However, when run on a client's machine using Excel 2000 and XP, this causes
the run time error.

Anyone have any ideas?
Reply With QuoteReply With Quote