Jim - Thank you for your help! It works great execpt for the two line
below. I need to sum the two offset cells * 1000. 2nd line i'm tryin
to offset, subtract the 3 cells, & then * 1000.



Range("C18").Select
Selection.Formula = "=Sum((Offset(Mountain!AJ80,0,c3*1)
offset(Mountain!AJ81,0,c3*1))*1000"

Range("C19").Select
Selection.Formula
"=Offset((Mountain!AJ87,0,c3*1)-c14-c15-c18))*1000"


Thank you for any help!

Pau

--
paull
-----------------------------------------------------------------------
paully's Profile: http://www.excelforum.com/member.php...fo&userid=3741
View this thread: http://www.excelforum.com/showthread.php?threadid=57202