Delete Row if Col C, 1st row starts with "Ar" & next row doesnt start

I'm pretty new to VB and am having difficulty accomplishing what I need. If anyone could be of any assistance, I would appreciate it. This is what I need:

If Row 1, Column C starts with "Ar" and the following row, same column, does not start with "Tq", then delete Row 1. If Row 2 . . . . etc.

[img=http://gtit.uspl.enbridge.com/SiteDirectory/GatheringField/BusProc/BP Picture Repository/test.jpg]
[hr]

Thank you.

Jackie
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories