View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Kevin Baker[_2_] Kevin Baker[_2_] is offline
external usenet poster
 
Posts: 13
Default VBA CODE to Subtract two cells

Doug,

Thanks, but I guess I didn't give enough info.

On my sheet I cell I2 needs to subtract cell F2 from cell H2.

I right click on the excel icon and select view code.. what do I do from
there?

Thanks,
Kevin

"Doug Glancy" wrote in message
...
Kevin,

Try this something like this:

= Worksheets("Sheet1").Range("F2").Value2 - Range("H2").Value2

hth,

Doug

"Kevin Baker" wrote in message
news:UPbee.660$It1.521@lakeread02...
Would like to use VB Code to do the following:

=F2-H2

Thanks,
Kevin