Excel Tables

0
We are using the following to simulate a DataTable. WorkSheet.AutoFilters.FilterRange = WorkSheet.Range. Is there anyway to add subtotals to the bottom of the range that will change based on the selected filter for the column?
 
asked 7/17/2020 7:35:58 PM
add a comment

1 Answers

0
I guess I can do the following; oTable = oWorkSheet.ListObjects.Create("Table1", oWorkSheet.Range). How can I add TotalFormulas to the table? Is this even supported?
 
answered 7/18/2020 12:09:16 PM
add a comment

Your Answer

Not the answer you're looking for? Browse other questions tagged excel or ask your own question.