I am attempting to subtotal using a For Each Next Construct; however, I do not know which "element" to use to identify a change in my range.
The syntax is as follows:
For Each element In group
[Instructions]
[Exit For]
[Instructions]
Next [element]
I am wanting a subtotal row for each change in range A8:A65536, but the VBA does not recognize "Change" as a valid element.
Any help will be greatly appreciated.
The syntax is as follows:
For Each element In group
[Instructions]
[Exit For]
[Instructions]
Next [element]
I am wanting a subtotal row for each change in range A8:A65536, but the VBA does not recognize "Change" as a valid element.
Any help will be greatly appreciated.