I am trying to write a formula for a range that links data Sheet1(Cashflows
PBEY) to Sheet2EY Cashflows), the data in sheet1 is linked to a sheet I
copied from another workbook, the code below for some reason brings up like
an open file dialog with a title of "Update Values: PBEY" and is prompting me
to select a file to open??? I've used this code before and never sow this
below, can this be because the original data is on a sheet I copied from
anothr workbook? Please help me out, thanks.

Sheets(EYCF).Select
'With Sheets(EYCF)


TopAdd = Range(Cells(StartRow, eycfcusip), Cells(StartRow, eycfcusip)).Address
BottomAdd = Range(Cells(intNumOfTrDesc + HdrRow, eycfcusip),
Cells(intNumOfTrDesc + HdrRow, eycfcusip)).Address
Range(TopAdd, BottomAdd).name = "temp"
Range("temp").Formula = "=" & Sheets(CFPBEY).name & "!" & "RC"

I want sheet2!A1 to be linked to sheet1!A1 and all the way down.