Cpearson Concatenate Array Function usage?

Thebatfink

Active Member
Joined
Apr 8, 2007
Messages
410
Hi,

I've trying to use the concatenate array function he has written on the page here http://www.cpearson.com/Excel/VBAArrays.htm

I have my arrays 'fn' and 'fn2' containing filenames which I want to join..

In my code I use

Code:
fn3 = concatenateArrays(fn, fn2)

but its just populating fn3 as 'True' and not the array values? I can only assume I'm calling the function incorrectly but I can't figure out what the correct way is! Help!!

Thanks!
Batfink
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
The function appends fn2 to fn and returns a Boolean indicating success, at which point fn should contain fn2 as well.
 
Upvote 0
Excellent. My poor understanding of the code at work again! Works fantastic. I should really read more of that site!

Thanks
 
Upvote 0

Forum statistics

Threads
1,224,603
Messages
6,179,854
Members
452,948
Latest member
UsmanAli786

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top