2D VBA array

[philaugust2004]

I know my problem is better done as a simple formula but I'm trying to get my head around arrays in VBA so this is an educational process rather than an efficiency one.

I have "First name" in Col A and "Surname" in Col b and want to have Col C as "First Name Surname"
With just one name I do this and it works fine.

Please Login or Register  to view this content.

But with multiple names I do this and it doesn't work

Please Login or Register  to view this content.

It's almost there as it copies each name and pastes in C but rather than each name in a single list it will copy a single name down the column and loop through each name like that. I have tried For Next which didn't work so any educational help would be appreciated.

[xlnitwit]

Hi,

You don't want to loop through each item in the array, only each row, so you can do something like this

Please Login or Register  to view this content.

It would be more efficient to write the results into another array and load that into column C at the end

Please Login or Register  to view this content.

[philaugust2004]

Thanks!
So Ii was right with For Next but made noobie error by using Range rather than cells and learnt a new function with UBound.
My code actually works if i use your cells line but I get an error at the end which I guess is a result of not using Ubound

[TMS]

Late to the party but here's a variation on a theme using just the one array:

Please Login or Register  to view this content.