Setting a range to understand letters

**DaveNUFC** · 05-10-2016, 02:14 PM

Hi,

I have some vba code which extracts data from a tab delimited file.
The code works in terms of finding (for example) where the first column = "123" however it doesn't pull back the records if there is a special character or a character there e.g. "12345-ABCDE" does not work.

I think this is to do with my range selection (as B2 is the driver behind that value).

Please Login or Register  to view this content.

**Richard Buttrey** · 05-10-2016, 02:31 PM

Hi,

Can you upload both the tab delimited file and the workbook with the macro. Manually add in the macro workbook the result you expect.

What do you do with the data once you have populated the array. I'm assuming you use the array to populate a range on a sheet.

Did you consider loading the parsed file directly or loading as it is and then using TextToColumns to create a range of columns?