Bruce,
I don't think you need the .Selection TheUsers is a Range and so is
Sheets("Users").Range("UserList")
Dan E
"Bruce B" wrote in message
...
I'm trying to reference a range in another sheet but same workbook:
Dim TheUsers As Range
Set TheUsers.Selection = Sheets("Users").Range("UserList")
However, I am getting the following error message:
Run-time error '91':
Object variable or With block not set
I'm using Excel 2000. Any help would be appreciated.
Thank you.
- Bruce
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!