Macro to Clear accounts starting with an X

[Howardc1001]

I have account numbers in Col A & B

where the account number starts with an X in Col A and b from row 2 onwards, i would like to clear these using a macro


I have tried to write code, but get a compile error "Next without for"

i have attached my sample data


It would be appreciated if someone could resolve this

Please Login or Register  to view this content.

[alansidman]

Look below at the addition in RED

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[sintek]

Clear or delete...

[Howardc1001]

Thanks for the pointers Alan

[Howardc1001]

Thanks for the help Fluff13

[Howardc1001]

need to clear the items starting with an X Sintek

[Fluff13]

Glad to help & thanks for the feedback