Hi,

Please can somebody help me with the formula for named cells

Partial code.........

Set Exp6 = Cells(H, 3)
Set Exp7 = Cells(I, 7)


ActiveCell.Offset(0, 1).Formula = "=exp6-exp7"

I just get #Name?

Thanks

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1