clear Items Col F based on Code Col B

[Howardc1001]

I have Suppliers codes in Col F. I need to clear the supplier codes in Col F where the Code on Col B is NOT KR-2200


I have written code to do this, but get an error message "method 'range' of object_Global failed

It would be appreciated if someone could amend my code

Please Login or Register  to view this content.

[vcoolio]

Hello Howard,

Try changing this line:-

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[jindon]

should be

Please Login or Register  to view this content.

If bulky data, autofilter would be better.

[vcoolio]

Hello again Howard,

If bulky data, autofilter would be better.

Ditto what Jindon said so something like the following would be better for a large data set:-

Please Login or Register  to view this content.

Cheerio,
vcoolio

[Howardc1001]

Hi Guys


Thanks for the help, much appreciated

[vcoolio]

You're welcome Howard.

Glad that we could help.

Cheerio,
vcoolio.