Macro to match left string

I am able to write a formula to extract the first 6 characters of a cell

= LEFT(A6, 6)

with A6 being the particular cell that the data is coming from

What I'm wanting to do is be able to insert a similar command into a macro that will delete the entire row for each row that has a specific string at the start of the cell contents. The loop will end when there is no data in column 1. There are thousands of records that I need to check this data from, and I'm not sure of how to do it

What I have so far is this, with the string that I'm looking for is "6digit"

Please Login or Register  to view this content.

with the red portion the code that I know is wrong. Any help on this would be greatly appreciated. Thanks

When I add this I get the following error

Compile error: Argument not optional

Originally Posted by Special-K

Does this work?

Please Login or Register  to view this content.

But this one worked

Thanks for the help

Originally Posted by arlu1201

Try this

Please Login or Register  to view this content.