cassidybklyn
Programmer
Gentlemen,
I am performing a count of unique items using "Subtotal" function. It is giving me count of the unique items everywhere they appear in the column.
What I want to do is first sort the unique items so that all unique items appear in a single location, then afterwards I can do my count.
This is the code I'm using to accomplish my count:
Selection.Subtotal groupBy:=7, Function:=xlCount, TotalList:=Array(7), _
PageBreak:=False, SummaryBelowData:=True
In otherwords, I want to sort the records based on the 7 column before executing the above routine.
Thank you.
C.
I am performing a count of unique items using "Subtotal" function. It is giving me count of the unique items everywhere they appear in the column.
What I want to do is first sort the unique items so that all unique items appear in a single location, then afterwards I can do my count.
This is the code I'm using to accomplish my count:
Selection.Subtotal groupBy:=7, Function:=xlCount, TotalList:=Array(7), _
PageBreak:=False, SummaryBelowData:=True
In otherwords, I want to sort the records based on the 7 column before executing the above routine.
Thank you.
C.