Clear Column Data with range

[rizmomin]

Hello:

I have
colpaste1 =Range("D2:D2")=BA
colpaste3 =Range("D4:D4")=BC



If Cell D2 = BA and D4= BC, i need VB Code to clear all contents in column BA to BC.


Note: BA and BC are the columns

Let me Know if you have any questions.
Thanks.



Riz

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[rizmomin]

Hi Richards:

Thanks a lot...works great.
Riz