Pull row or part row from array

[Westbury]

I've seen VBA Array - is there a quick way to export an entire row of a 2 dimensional array to a worksheet range?

but is there a way of pulling part of a row from an array into a spreadsheet? e.g. array(2,2) to (2,5)

 

[Fluff]

You could use something like

   Dim Ary As Variant, Nary As Variant
   
   Ary = Range("A2:Z100").Value
   Nary = Application.Index(Ary, 2, Array(2, 3, 4, 5))

 

[Westbury]

Fluff,

Nice concise solution.
Many thanks.
Geoff

 

[Fluff]

You're welcome & thanks for the feedback.