On Tue, 23 Sep 2008 06:53:01 -0700, Office_Novice wrote:

Greetings, I know this is possiable but can't seem to get the syntax right. I
want to take a range from a worksheet if a condition exists and assign it to
an Multidimensional Array to be added to another worksheet later. how is
this done?

Maybe you can add a reference to that range and store it to your array, so
you can call it later?

B.