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

Hi,

Depending on where you want it to go, I'm making some assumptions here ...

Range("A1").Value = Range("F2").value - Range("H2").value

or

Range("A1").formula = "=F2-H2"

--
Regards,
Zack Barresse, aka firefytr

"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