View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] tanglk@gmail.com[_2_] is offline
external usenet poster
 
Posts: 2
Default How to put this formula using VBA

i want to put this formula to column F using VBA where the row number
will change accroding to row number

=IF(E7="CB",A7&(D7*-1),A7&D7)

Hope you all can help me.

regards