refer part of a multi dimension array

I have a 2 dimensional array: ar(1 to 2, 1 to 100). I need to refer to the first element of the first dimension ar(1, 1 to 100) without creating a new one. Is that possible? The reason I don't want to create a separate new array is because I need to use the value of the the second element of the first dimension ar(2, 1 to 100). For example something like:

for i=1 to 100
     ar(1, i)=worksheets(i).name
     ar(2, i)=worksheets(i).index
next

Then I want to do something like:

for x=1 to 100
   anotherAr(x)=application.worksheetfunction.large(ar(1,1 to 100),x )
next

But I don't think ar(1, 1 to 100) is recognized.

To give a better explanation, for example, I need to create an array of the worksheet name sorted with their corresponding indexes based on the array of randomized sheet name and their indexes. I know this may not be the best description of my problem and I know there are other ways to achieve this specific goal but I am wondering if an array can be used so I can use it for other purposes. Many thanks in advance!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Edit: OP changed requirements

So you need the names of the worksheets sorted? What are you going to do with the array?

Sub ad()
  Dim av As Variant
  av = [{1,2,3;4,5,6}]
  
  ' first row
  Range("A1").Resize(, 3) = WorksheetFunction.Index(av, 1, 0)
  ' second row
  Range("A3").Resize(, 3) = WorksheetFunction.Index(av, 2, 0)
  ' first column
  Range("A5").Resize(2) = WorksheetFunction.Index(av, 0, 1)
End Sub

Perhaps you could use Index, here's a very simple example.

Dim x
Dim y
Dim z

    x = Range("A1:D15")
    
    y = Application.Index(x, 1)
        
    z = Application.Index(x, , 1)

y will return a 1-dimensional array with the values from A1:D1.

z will return a 2-dimensional array with the values from A1:A15.

@ shg

I prefer to use Application instead of worksheetfunction because in case of error the Worksheetfunction goes into debug while the Application variant gives error on worksheet but code runs through.
Also with the Application variant you can easily trap the error using IsError and act accordingly.

Just a thought.