Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
DEAR ALL
I intended to use the result of RCOUNT variable to various other procedures. So I have named a cell by name REF_NUMBR. Flg is the vb code: Set COL_F = Range("F5.F20") RCOUNT = Application.CountA(COL_F) 100 Names("REF_NUMBR").Value = RCOUNT but at line 100 it gives error saying application-defined or object- defined error. Then I made it as activeworkbook.Names("REF_NUMBR").Value = RCOUNT and it accepts. Instead of the above if i use Range("REF_NUMBR").Value = RCOUNT it takes the value. Earlier i was using activesheet.range("a1").value = RCOUNT and was referring to this range. Pls advice how to use the line 100 correctly using the 'NAMES' and shortest code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application-defined or object-defined error (worksheet, range, sel | Excel Programming | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Dictionary object: Error assigning user defined data type to item | Excel Programming | |||
Range - Application Defined or Object Defined Error | Excel Programming | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming |