bhofsetz, Thanks for getting back to me

I can't seem to get that to work. I don't want to hardcode the link to
the outside worksheet because this macro will be used with different
spreadsheets. So I tried to create a variable that would call the cell
outside the worksheet where the macro sits.

I don't know if I explained my problem very well so here is a copy of
part of the macro that I'm working on.

Application.Workbooks(DataEntryVar).Worksheets("Ca sualty
Income").Activate
Dummy1 = Range("G8").Address

Windows("Stewardship MACRO.xls").Activate
Dummy2 = Range("D2").Address

MajorClass = "Casualty Income"

Temp = Path & "[" & Company & "]" & MajorClass & "!'" & Dummy1

Range("C2").Formula = D2 + Temp


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=379509