add to a range instead of setting?

[primprim]

Hi,
I am trying to select a range given a if condition. this is what ive sritten so far...

Please Login or Register  to view this content.

however, it only selects the last TRUE cell... im guessing thats because it resets Other every time... how should i rewrite this to work? is there a way to add to a range instead of "setting" a range?

Im basically trying to group a pivot table using a condition and therefore needs to find a way to select a number of cells.

thanks!

[mikerickson]

You can use Application.Union to combine cells.

Please Login or Register  to view this content.

[primprim]

thank you! exactly what i was looking for!