Functions

Hi Olufunke

Thanks for the update


If I understand correctly you want to filter your record on a certain criteria (e.g. Client Name) and then count how many records there are that match this. You then also want to know how many additional records there are.

This is quiet a complex thing to do in code, but the general strategy would be to:

1. Use the count method of the rows collection of the current region to determine how many records there are in total, and assign this to a variable (intTotalCount)
2. Use the filter method of the selection object to filter the data. (I suggest recording a macro to see the code for this)
3. Then repeat step 1 for the filtered data saving that to a variable(intFilterCount)

IntFilterCount will give you the number of items in the filtered data and that less intTotalCount will give you the balance

If you have any problems please do follow up to my post

Regards

Stephen