Keep getting an error when trying to return array from function

[cosmicwinds]

I just can't seem to get this code to work properly.... Can anyone help me out Thanks,
-Tyler

Please Login or Register  to view this content.

Here is the portion which calls the function

Please Login or Register  to view this content.

The error I am getting is Type mismatch, but I guess i'm too stupid to see the issue xD.

[6StringJazzer]

Can you be more specific? What line does the error occur on?

[MarvinP]

Hi cosmicwinds...

In looking at your code, it looks like you are trying to open a group (perhaps a single) file or table. Then you seem to go through some cleanup using array functions. You need to know that arrays start with a zero base.

I have another suggestion that might be better....

Excel 2010 and 2013 have an Add-in called Power Query that will open a group of files or single file and do cleaning on it. You will need to install this add-in but it looks like it is what you are really looking for. Think of Power Query of a tool, like Pivot Tables or Charts that has been added to Excel to do these type of import and cleanup tasks.

https://www.microsoft.com/en-us/down...9-b3402ee5376b