You could avoid some of the Activating that you have going on by
assigning your Dummy1 variable directly

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

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

Also, if your destination cell is always D2 then you don't need Dummy2
(you aren't using it right now anyway)
And if the macro is running from the "Stewardship MACRO.xls"
then you can simplify things by using:
ThisWorkbook.Range("C2").Formula = "=D2" & "+" & Te

This is untested but give it a try:

Code:
--------------------
Dummy1 = Application.Workbooks(DataEntryVar).Worksheets("Ca sualty Income").Range("G8").Address
MajorClass = "Casualty Income"
Te = "'" & Path & "[" & Company & "]" & MajorClass & "'!" & Dummy1
ThisWorkbook.Range("C2").Formula = "=D2" & "+" & Te
--------------------


HTH


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