Hi All,

I can't seem to get the correct "syntax" for this formula.

oexcel.activesheet.range("c4:c" + ltrim(str(ntotalrow))).formula = "=SUM("+thisform.r_salepool+"/"+thisform.r_syn+"*b4)"

Apparently the form's propertie's values are not being read properly and the cells in the third("C") column have no values and no formula.

thisform.r_salepool = $600,000 && fees collected

thisform.r_syn = 23 && pooled bookings

The cell B4 contains a value which represents the number of pooled bookings out of the total of 23.

(ie; 600000/23*2=$52,173.00


I've tried many different variations with no luck.

I'd appreciate it if someone could steer me in the right direction on how to correctly list the form properties.

TIA

Jim Harvey