pastelrain
Registered User.
- Local time
- Yesterday, 22:47
- Joined
- Jul 12, 2016
- Messages
- 23
Hi,
Does anyone know why the subtotal code below would only work with one column instead of all? It only sums the last (total) column. It's almost as if it doesn't recognize the other columns can be summed. They are all in the same format (General).
Any help is appreciated!
Set tbl = xlWS.ListObjects.Add(xlSrcRange, rng, , xlYes)
tbl.TableStyle = "TableStyleMedium2"
tbl.ShowTotals = True
Does anyone know why the subtotal code below would only work with one column instead of all? It only sums the last (total) column. It's almost as if it doesn't recognize the other columns can be summed. They are all in the same format (General).
Any help is appreciated!
Set tbl = xlWS.ListObjects.Add(xlSrcRange, rng, , xlYes)
tbl.TableStyle = "TableStyleMedium2"
tbl.ShowTotals = True