Failing to assign expression to FormulaR1C1, what am I doing wrong?

  • Thread starter Thread starter SysRq2000
  • Start date Start date
S

SysRq2000

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY BY MACRO DOWN TO LAST VALUE CELL IN COLUMN "A" 1
formula construction 2
Error when doing a paste 3
Late Binding - SORT driving me crazy 6
What is wrong with this code?!? 1
What am I doing wrong 3
What am I missing here? 4
What am i doing wrong here? 5

Back
Top