ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Convert Range to Array (https://www.excelbanter.com/excel-programming/417484-convert-range-array.html)

Office_Novice

Convert Range to Array
 
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[_3_]

Convert Range to Array
 
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.


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com