View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
 
Posts: 65
Default Subtract named cells

Thanks for everybodys help.

Change of plan I think im going to show Exp6 and Exp7 then do the subtraction


Bob Phillips wrote:
Cells(3,"H").name = "exp6"
Cells(7,"I").Name = "exp7"
ActiveCell.Offset(0, 1).Formula = "=exp6-exp7"

Hi,

[quoted text clipped - 12 lines]

Darren


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