Clearing Contents

Hi,

I have the following code (an extract of it):

Please Login or Register  to view this content.

I would like to re-write the above in just 2 lines, meaning, I would like to have a command that can select the Active Row cell contents from B:H and then perform the "Selection.ClearContents".


regards,
makku

Thanks.

Please Login or Register  to view this content.

Hi,

In just one line

Please Login or Register  to view this content.