Hiall,
Using Excel 2013.
How do I get the total to show in the footer for each column in a Table (ListObject) not just the last column?
thx
w
![]()
With ws Set rng = .Cells(1, 3).CurrentRegion Set loSummary = .ListObjects.Add(SourceType:=xlSrcRange, _ Source:=rng, _ Destination:=.Cells(1, 3)) With loSummary .Name = "Summary" .TableStyle = "TableStyleMedium2" .ShowTotals = True End with end with
Bookmarks