Space in formula (excel xp)

[jha900]

I'm writing a macro where i'm putting 2 cells that are separated by a space on sheet2.

I can recreate it except for the space in between the 2 cell references.

ActiveCell.FormulaR1C1 = "='shee1'!RC & "" "" & 'sheet1'!RC[1]"

How can i write the above in a vba module? Thank you for the help.

[pieterse]

Like this:

ActiveCell.FormulaR1C1 = "='sheet1'!RC & "" "" & 'sheet1'!RC[1]"

[jha900]

ok, thank you. What if the 'sheet1' is a variable called shtName? I tried this and it doesn't work

ActiveCell.FormulaR1C1 = "=shtName & "!RC & "" """ & shtName & "!RC[1]"

[sdckapr]

ActiveCell.FormulaR1C1 = "='" & shtname &"'!RC & "" "" & "'" & shtname & "'!RC[1]"

Steve

[jha900]

ok i used this

shtname = "11mvs"


ActiveCell.FormulaR1C1 = "='" & shtname &"'!RC & "" "" & "'" & shtname & "'!RC[1]"

and get error 1004, application.defined or object error. am i missing a quote somewhere because when i cursor over the first shtname it says 11vs but when i cursor over the 2nd shtname it shows nothing. thanks

[sdckapr]

Try this:
ActiveCell.FormulaR1C1 = "='" & shtname & "'!RC & "" "" & '"& shtname &"'!RC[1]"

My mistake I had an extra dbl-quote in it.

Steve