Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2003, I have a workbook with a single sheet. A single cell on
that sheet is a named range with name "bbb". If I try to run: Sub jnk() Dim i As Long i = Range(Names("bbb")) End Sub I get an "application defined or oblect drfined error", yet if I type i = Range(Names("bbb")) ?i in the immediate window, I get no error and the correct value of i is displayed. What is wrong with my Sub? Thanksfor your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem copying named range | Excel Programming | |||
Find in Named Range problem (2nd Try) | New Users to Excel | |||
Named Range Problem | Excel Programming | |||
named range problem | Excel Programming | |||
Link problem with named range | Excel Programming |