Convert Range to Array

[Office_Novice]

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?

 

[Boris]

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.