Posted to microsoft.public.excel.programming

sid[_3_]

external usenet poster

Posts: 11

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 ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RUNNING TOTALS...FORMULA NEEDED	Liz	Excel Worksheet Functions	2	July 31st 07 07:43 PM
Formula needed to create grand totals	Daniel LEYVA	Excel Worksheet Functions	1	October 14th 06 09:18 AM
Help needed Writing formula that totals data at end of column	sid[_3_]	Excel Programming	0	May 12th 06 02:34 PM
Help needed with writing a formula	Karl	Excel Programming	6	February 17th 04 04:34 PM

All times are GMT +1. The time now is 08:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us