You're missing a "."

Then
<fullstopOffset(N, 2).FormulaR1C1 = "=(RC[-2])"

NickHK

"VBNewbie" wrote in
message ...

Many thanks NickHK, I tried to test your code line but i facing the
compile error for the code line below:


If IsEmpty(.Offset(N, 2).Value) And IsNumeric(.Offset(N, 2).Value)
Then
Offset(N, 2).FormulaR1C1 = "=(RC[-2])"


--
VBNewbie
------------------------------------------------------------------------
VBNewbie's Profile:
http://www.excelforum.com/member.php...o&userid=36526
View this thread: http://www.excelforum.com/showthread...hreadid=562776