Brian C Wrote:
I need a way to accomodate the two files with the same statement.

Why do you need to do this? Maybe just use an if statement

If Selection.Worksheet.Name = "Sheet1" Then
enter your first formula
Else
enter your second formula
end i

--
Mallyca
-----------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...fo&userid=3551
View this thread: http://www.excelforum.com/showthread.php?threadid=55383