Macro to clear contents

[bigband1]

Hello all
I have a spreadsheet around 70000 rows long,i would like to use a macro to do the following.If any cell in Col AB contains "first" then clear the contents from Columns AK,AL,AM in the specific rows where Col AB contains "first".The cols AK,AL,AM contain numeric data only.Many thanks for help given.

[PaulG2011]

Hi bigband,

So what have you tried so far? Did it work?

I would use a sub of the format:

Please Login or Register  to view this content.

This assumes that your data starts on row 1, and that your sheet is called sheet1.

Hopefully will get you started!

Kind regards,

Paul

Edit: Note that if your cell value in column AB starts with the word first, then Instr returns 0, which means that the macro will not clear the data. For example:

4373first would return a value greater than zero when you test Instr(), but
first43425 would return 0.

so in the top case the cell contents would get cleared, and in the bottom case they wouldnt. You could make it clear the cell contents in any case by having something like:

If InStr(testcell, "first") > 0 or testcell = "first" Then

Happy coding!

[royUK]

Depends on the data layout but autofilter would be the quickest way. Automate with VBA if realy necessary