List of Unique Values

I have a table in excel in which I have several different scenarios and each scenario involves a series of control points (some scenarios repeat control points, some don't.) I was curious if there is a way to use VBA to generate a list of all the unique control points.

You don't need VBA, you can do it with Data>Filter>Advanced Filter and check
the Unique Records box.

--
HTH

Bob Phillips

"cmk18" <[email protected]> wrote in
message news:[email protected]...
>
> I have a table in excel in which I have several different scenarios and
> each scenario involves a series of control points (some scenarios
> repeat control points, some don't.) I was curious if there is a way to
> use VBA to generate a list of all the unique control points.
>
>
> --
> cmk18
> ------------------------------------------------------------------------
> cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
> View this thread: http://www.excelforum.com/showthread...hreadid=381572
>

That produces a static list though, I need somethign that changes as you add or delete nodes. Is there someway to use this functionality in VBA (maybe the in the Worksheet_Activate sub routine) to make the list dynamic?

You could use filter in a worksheet change event to generate a unique list.

--
HTH

Bob Phillips

"cmk18" <[email protected]> wrote in
message news:[email protected]...
>
> That produces a static list though, I need somethign that changes as you
> add or delete nodes. Is there someway to use this functionality in VBA
> (maybe the in the Worksheet_Activate sub routine) to make the list
> dynamic?
>
>
> --
> cmk18
> ------------------------------------------------------------------------
> cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
> View this thread: http://www.excelforum.com/showthread...hreadid=381572
>