Hello All,

I am formating a text file that comes from outside of the microsoft world, and then putting the required information into a new worksheet.

My method is to populate the multi dimension array with the text file, and the build up the dynamic arrays with the information that I require. One of the dyanmic arrays contains part numbers.

All this worked very well until I added a vlookup step.

I wanted to be able to populate another dynamic array which contains part descriptions based upon the contents of the part number, using infromation that comes from a second multi-dimension array.

The reality is that when you step through the program it works, but when you run it, it becomes really very slow, to the point where I have always had to break the program. When you look at the watch counter it appears to work but slow.

Below is the line of code that I've used, without it the program runs as it should.

Please Login or Register  to view this content.
The vaHCP array is populated with a named range.

Could someone explain why the program would run so slow, and offer a way round this. I could do a vlookup outside of the array, but it just seems neater and a logical place to do this within.

Thanks for your help.