Help needed Writing formula that totals data at end of column
 

Hi DS,
this is just an update.
to get your formular working in access I am having to transpose it
something like this.

Excel.WorksheetFunction.Sum("J65536").End(xlUp).Of fset(rowOffset:=1,
columnOffset:=0).Activate

but this still does not work.

regards,

Sid.



*** Sent via Developersdex http://www.developersdex.com ***