View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Straightpool Straightpool is offline
external usenet poster
 
Posts: 2
Default Creating Formulas using BV

I need to create a formula in a VB macro based on the ActiveCell. The formula
should look like the following:

=IF(ISBLANK(J7),,I7/J7)

I7 & J7 will change based on the current row.

I am new using VB so any help will be greatly appreciated.

Thanks,
Brad