Excel automation in VB.NET

M

Mister T

Hello,

I have done some Excel-to-VB.NET automation, so I am familiar with the
basics. I have gotten stuck on doing Subtotals.

The VBA macro looks like this::


..Selection.Subtotal(GroupBy:=2, Function:=xlSum, TotalList:=Array(5),
Replace:=False, PageBreaks:=False, SummaryBelowData:=True)

I cannot figure out how to reference the "Array(5)" object in VB.NET. Any
ideas?

Thanks for any suggestions.
Mister T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Formatting 2
Macro Pause to Select range then Subtotal 0
Subtotal by VBA 5
macro excel subtotal in subtotal 2
.SubTotal: Controlling where the caption goes? 0
SubTotal in Excel 1
Excel Subtotals 2
Issue with nested data subtotals 3

Top