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.
|