Hi. I have the following two lines in a macro to copy/paste the sam
expression to about 23000 rows.
Sheet2.Range("B2").FormulaR1C1
"=OR(ISBLANK(RC15);ISBLANK(RC16))"
Sheet2.Range("B2").Copy Sheet2.Range("B2:B" & g_LastRowIndex)
However when the first line is executed it fails with
"Application-defined or object-defined error" message, aka. error 1004
What am I doing wrong? Btw, if you remove the "OR" statement from th
expression, the line doesn't fail... Isn't that odd?
Thx in advance,
Johanne
--
SysRq200
-----------------------------------------------------------------------
SysRq2000's Profile:
http://www.excelforum.com/member.php...fo&userid=1453
View this thread:
http://www.excelforum.com/showthread.php?threadid=26153