Cell Reference in VBA

[cmz21]

hello,
I am using the following code to create a formula in a cell which refers to a cell on another worksheet -

xlSheet.Range("I21").Formula = "='Worksheet Name'!E29"

Every time I try to run the code, a browse for file dialog box opens up. How can I tell the code to use the named worksheet from the same workbook?

Hope this makes sense.
thanks for any help

 

[cmz21]

I have solved my own problem. In my coding, I stupidly didn't take into consideration that I was creating a new workbook and was trying to reference the second sheet before it was actually created. I moved that line of code to the end of my sub and it worked fine.

thanks