Just for completeness. there was a typo

ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 & _
" + '" & sheetname & '!R[5]C[3]"

should have been

ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 & _
" + '" & sheetname & "'!R[5]C[3]"

--
Regards,
Tom Ogilvy


"Eric Silva" wrote in message
...
I don't know what I did but it suddenly started working just right.
Thanks a
lot for the help, Tom. I read some of your other posts before I put this
one
up and you're both knowledgeable and helpful. Keep it up! I might have
another question someday.

"Eric Silva" wrote:

At first, I copy-pasted the code into my program, then I compiled, got
an
error, read through it and saw only three quotes. I added a quote to
the
line right before the second apostrophe and got this:

ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 & " + '" & sheetname &
"'!R[5]C[3]"

This gives me the 1004 error, so it's still not reading something in the
second half of the statement as the correct object type to be going into
an
excel formula. What's still wrong?