vba clear contents of range of columns with certain criteria

[bkeat]

hi

Just wondering is it possible to clear cells multiple columns based on the criteria instead of column by column.
For example:
What i am trying to do i have a file with 28000 lines and want the macro to clear contents of the cells in columns W,X,Z,&AA that contain #N/A.

Can this be done ? Your wisdom would be great

[AB33]

Clear the entire column.

Please Login or Register  to view this content.

[bkeat]

This is what i have, i wanted to delete in the range all together if possible for the cells containing "#n/a"

Please Login or Register  to view this content.

[AB33]

But you said across columns, not a single column which you have is 24. Yes, filter works with a single column.

[bkeat]

Sorry for being unclear. This is what i have yes i do it column by column. I was wondering could i do it all in one to speed up my macro?
So i want to FIND all #n/a in columns W,X,Z,&AA and remove the #n/a leaving the cells blank.

[AB33]

The code does as long as you are clearing an entire column. There is no need to loop, but if you want to clear a single cell, you may need to loop through the cells.

Could you please attach a sample?

[bkeat]

This is what i ended up using. I just did this for every column i needed to clear. Alot of code but works.
Maybe there is a better solution?

Please Login or Register  to view this content.

[AB33]

You could have all 4 filters in one code, but need to see and taste a sample book.

[bkeat]

Just for info after further research I used the replace function much more efficient thanks for your help.