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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
On Feb 16, 8:56 am, "CAPTGNVR" wrote:
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. Line numbers in this case are really labels. to use it put a colon after it. 100: Names("REF_NUMBR").Value = RCOUNT But this line defines your named range "REF_NUMBR" = COUNTA In other words, your range doesn't mean anything. Were you trying to set a cell value to COUNTA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
Names("REF_NUMBR").referstorange.Value = RCOUNT
But I like: worksheets("Somesheet").range("ref_number").value = rcount CAPTGNVR wrote: 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. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
On Feb 16, 11:48 pm, "Don Guillett" wrote:
Maybe I'm missing something. Try Sub countcolf() range("REF_NUMBR").value= Application.CountA(range("f5:f20")) End Sub -- Don Guillett SalesAid Software "CAPTGNVR" wrote in message ups.com... 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. Thnk u Don. Actually i find it difficult to put it down in writing in this forum. Luckily i got the answer from Mr. Dave. I wanted to know how to use the Name property as i was getting error when i use. Now this thread i can consider closed once i get from Dave how to set a variable to the whole line defining the range. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
On Feb 16, 11:43 pm, Dave Peterson wrote:
Names("REF_NUMBR").referstorange.Value = RCOUNT But I like: worksheets("Somesheet").range("ref_number").value = rcount CAPTGNVR wrote: 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. -- Dave Peterson Thnk u Dave. Frankly on this ship I have learnt so many things thro this forum thanks to u. I got what i wanted. How to use the property names. It worked. Can u take me to the next step?? Instead of writing the whole thing like --- worksheets("Somesheet").range("ref_number").value = rcount--- can u suggest how to set this as public and set a variable so that i can reference this without having the need to type the whole thing. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
On Feb 16, 11:21 pm, "okrob" wrote:
On Feb 16, 8:56 am, "CAPTGNVR" wrote: 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. Line numbers in this case are really labels. to use it put a colon after it. 100: Names("REF_NUMBR").Value = RCOUNT But this line defines your named range "REF_NUMBR" = COUNTA In other words, your range doesn't mean anything. Were you trying to set a cell value to COUNTA? thnk u OKROB. But the line number i am not using it in the VB. I missed to tell that i used here in this just to refer the line. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
Dim myImportantCell as range
'or outside the procedure 'Public myImportantCell as range .... set myimportantcell = worksheets("Somesheet").range("ref_number") .... myimportantcell.value = rcount You'll want to use a shorter, more meaningful name for that cell. CAPTGNVR wrote: On Feb 16, 11:43 pm, Dave Peterson wrote: Names("REF_NUMBR").referstorange.Value = RCOUNT But I like: worksheets("Somesheet").range("ref_number").value = rcount CAPTGNVR wrote: 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. -- Dave Peterson Thnk u Dave. Frankly on this ship I have learnt so many things thro this forum thanks to u. I got what i wanted. How to use the property names. It worked. Can u take me to the next step?? Instead of writing the whole thing like --- worksheets("Somesheet").range("ref_number").value = rcount--- can u suggest how to set this as public and set a variable so that i can reference this without having the need to type the whole thing. -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
On Feb 17, 1:02 am, Dave Peterson wrote:
Dim myImportantCell as range 'or outside the procedure 'Public myImportantCell as range ... set myimportantcell = worksheets("Somesheet").range("ref_number") ... myimportantcell.value = rcount You'll want to use a shorter, more meaningful name for that cell. CAPTGNVR wrote: On Feb 16, 11:43 pm, Dave Peterson wrote: Names("REF_NUMBR").referstorange.Value = RCOUNT But I like: worksheets("Somesheet").range("ref_number").value = rcount CAPTGNVR wrote: 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. -- Dave Peterson Thnk u Dave. Frankly on this ship I have learnt so many things thro this forum thanks to u. I got what i wanted. How to use the property names. It worked. Can u take me to the next step?? Instead of writing the whole thing like --- worksheets("Somesheet").range("ref_number").value = rcount--- can u suggest how to set this as public and set a variable so that i can reference this without having the need to type the whole thing. -- Dave Peterson Thank u v/much Dave. Custom made and clearly ustood how to do it. |
Reply |
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 |