filter data from txt file

[eherr9633]

Why isnt this script working. I just want the company names.

Please Login or Register  to view this content.

sheet looks like this:

Down Column A

Company Name
Pizza

Company Name
HotDog

Company Name
Salad

Company Name
Phone

etc.....

it'll output the first three company names( hotdog, pizza,...) ..skip the next 2 and then pick up and skip again.


Thanks in advance

[snb]

Please Login or Register  to view this content.

[Leith Ross]

Hello eherr9633,

The problem with the code is MyRow = MyRow + 1. MyRow is the control index value for the loop. It is a bad programming practice to modify this value. The If statement determines if the cell contents are to be written to the file. There is no need to increment the control index value because the loop does that for you. Here is working version of your macro...

Please Login or Register  to view this content.

[eherr9633]

That makes absolute sense I am cannot believe I over looked that!!

Thanks a lot

Hello eherr9633,

The problem with the code is MyRow = MyRow + 1. MyRow is the control index value for the loop. It is a bad programming practice to modify this value. The If statement determines if the cell contents are to be written to the file. There is no need to increment the control index value because the loop does that for you. Here is working version of your macro...

Please Login or Register  to view this content.

[snb]

There's no need for a loop as you can see in this maybe overlooked this suggestion.