VB Code Range

[rizmomin]

Hell:

I wanted to create a VB Code

Please Login or Register  to view this content.

And i am using below without any problem.

Please Login or Register  to view this content.

where value if D2 = AJ and D4=AK. which will give result as =Range(AJ:AK).Clearcontents.

Now instead need a formula as below:

Please Login or Register  to view this content.

Basically i need a formula to clear part of the column instead of whole column.

Let me Know if you have any questions.
Thanks.



Riz

[haripopuri]

Please Login or Register  to view this content.