Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range on another sheet | Excel Worksheet Functions | |||
referencing a 3D Named Range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Refer to Named Range on another sheet for IF function | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |