Using variable in Application.Index

Hello. Hopefully this is an easy question to answer. I am attempting to write the results of an index function performed on an array to another array. I am using the following:

Please Login or Register  to view this content.

works as expected. If instead, I substitute the "test" variable for "10" in "[row(1:10)]," I receive Error 2015. Is there a way to use a variable in place of a constant here? I am trying to write certain columns to the array, and the number of rows changes constantly.

Thanks,

Mayday

Hi & welcome to the board.
How about

Please Login or Register  to view this content.

Ugh. I wondered if Evaluate would work but wasn't sure of my syntax since the original uses square brackets. Worked perfectly. Thanks!

Thanks for the welcome! I have never posted before because I usually find the answer posted already!

Glad to help & thanks for the feedback.