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?