VB Code to clear contents of certain columns

[rizmomin]

Hello:

I need VB Code to ClearContents the data in
Column(O:P),
Column(S:T),
Column(W:X) and so on until last Column(EE:EF)

Please let me know if you have any questions.
Thanks.

Riz

[Crooza]

Give this a try

Please Login or Register  to view this content.

[alansidman]

Try this on:

Please Login or Register  to view this content.

[Crooza]

@Alan

If I'm reading your code right it will continue while ever there is content in cells and I'm not sure if the OP wants to continue past EE:EF even if there is content in the cells.

[alansidman]

Crooza: True. I interpreted and maybe incorrectly that the file may have ended at columns EF. Excellent catch. Let's see what the OP says.

[rizmomin]

Hi Crooza and Alan:

Code works great, i will be implementing Crooza code.
Thanks both for great help.
Riz