How to input a column(50x1) of a stored array(50x50) as an input to a function??

[Punar]

I have an array of 50x50 size. The array is stored and is not displayed anywhere on the spreadsheet. I need to give the columns(50x1) one by one as input to a function. What is the quickest way of doing this using VBA?
Please help me!

 

[Jon von der Heyden]

I need to give the columns(50x1) one by one as input to a function.

I don't fully understand what you are after, but I will hazard a guess that you need the Index function. You can use Index to pull specific columns of your 50 row array. E.g:

TempArray = Application.Index(VarArray,0,3)

The 0 will ensures that all 50 rows are returned. The 3 captures only the 3rd column.

 

[Punar]

I don't fully understand what you are after, but I will hazard a guess that you need the Index function. You can use Index to pull specific columns of your 50 row array. E.g:

TempArray = Application.Index(VarArray,0,3)

The 0 will ensures that all 50 rows are returned. The 3 captures only the 3rd column.

Thank you so much Jon!!
That was exactly what I needed!