Assigning an Array value from one worksheet to a cell in another worksheet

[DonEB]

I've spent some time searching on the internet how to handle this issue but I think I may be phrasing the questions or issue incorrectly and I have not been able to find any material on how to handle. So... here my simple problem:

I have create an array (array_Chart10a) located in a worksheet called TeamSelection2 within the following cells: G7:J501.

I'm attempting to take the value located in G7 and place it in cell AQ4 which is located within another worksheet called TeamSelection.

Because I need to examine/analyze information in the first few lines, I am performing this while doing a "While Counter1 < 20" loop. As a result, I have attempted to use the following code:

Sheets("TeamSelection").Range("AQ4").Value = Sheets("TeamSelection2").array_Chart10a(Counter1,1)

I get a "Run-Time Error: "438", Object doesn't support this property or method.

I'm stumped... any help will be appreciated.

Thanks,
Don

 

[Marcelo Branco]

Provided the array is already defined in some code line above, like
array_Chart10a =Sheets("TeamSelection2").Range("G7:J501").Value

you can simply use
Sheets("TeamSelection").Range("AQ4").Value = array_Chart10a(Counter1,1)

M.

 

[DonEB]

Thank you "M".

After scanning back through my code, I discovered that I failed to correctly define my array. Once I did that... the coding you provided worked as I had hoped it would.

Thanks again!!
Don

 

[Marcelo Branco]

You are welcome. Glad to help.

M.