What is wrong with this code? (Extract Row from 2D array to 1D array)

**mc84excel** · 05-10-2013, 06:39 AM

I'm getting really frustrated.

I have this code and I can't work out why it isn't working. (The intRowToReturn is Variant instead of integer/long because I have to pass a project level byte to this function. Surely this isn't the cause? or is it?)

Please Login or Register  to view this content.

**Andy Pope** · 05-10-2013, 06:50 AM

Please Login or Register  to view this content.

Did you really want to Erase the incoming array?

**Kyle123** · 05-10-2013, 06:53 AM

Can't you just use index?

http://www.excelforum.com/tips-and-t...2d-arrays.html

**mc84excel** · 05-10-2013, 07:14 AM

Thank you +1

Originally Posted by Andy Pope

Did you really want to Erase the incoming array?

Yes I do (and thanks for checking). I want to extract the one relevant row from the input array as a new array. I have no use for the input array afterwards.

**mc84excel** · 05-10-2013, 07:17 AM

Originally Posted by Kyle123

Can't you just use index?

I might if I knew how to write the code as Index (I'm not familiar with use of Index). But I haven't got the time/patience to work that out. Andy Pope has provided working code and as long the code works for me, I'm happy.