Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 Tags
Subject: RE: Calling Auto subtotal Function in Excel
Thread ID: 228076 Message ID: 228662 # Views: 3 # Ratings: 1
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Wednesday, May 20, 2009 3:57:07 PM         
   


> dimension atemp[1]
> atemp[1] = INT(ia/6)+1 && number of expected groups
>
> .ActiveSheet.Range("A2:B11").Subtotal(1,xlSum, @atemp,.t.,.f.,.t.)

I think there is a typo here.

aTemp[1] = 2 && Column(s) # to total


Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)

ENTIRE THREAD

Calling Auto subtotal Function in Excel Posted by Muhammad Zahid @ 5/15/2009 8:00:02 AM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/15/2009 5:08:19 PM
RE: Calling Auto subtotal Function in Excel Posted by Muhammad Zahid @ 5/20/2009 8:19:33 AM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/20/2009 3:32:14 PM
RE: Calling Auto subtotal Function in Excel Posted by Cetin Basoz @ 5/20/2009 3:57:07 PM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/20/2009 4:31:16 PM