View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] idyllicabyss@googlemail.com is offline
external usenet poster
 
Posts: 32
Default Worksheet name problem

The worksheet name should be able to include spaces if you enclose it
in speechmarks the same as if you were referencing it any other time in
VBA.
Otherwise try refering to the sheet directly via it's (name) rather
than it's name, eg sheet1.
For instance, ,although Sheet1 is renamed "User Data", it can still be
referred to explicity as Sheet1 without the speechmarks, as long as
it's (name) has not been changed.
If this doesn't make sense, open VBA and view the properties for any
sheet, you should see (Name) at the top of the list and Name just after
EnableSelection.