Referencing Named Range in Other Sheet
 

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!