Home » Forums » Open Source Learning Center » Question and Answer

Create a Macro that will delete a cell range on print

Submitted by rob.surina on 21 August, 2015 - 00:23

I'm trying to do something like this:

Sub Clear_Cells()
worksheet ("Data").range(C1:C11).clear contents on print

End Sub

But doesn't work. Any ideas.
Any help would really be appreciated

Thanks, Rob

‹ Automatically remove rows in Excel based on values Create a Macro that will delete a cell range on print ›
»

create-macro-will-delete-cell-range-

Submitted by VKYVBA on 21 August, 2015 - 13:52.

Dear Rob.surina,

Sub Clear_Cells()
worksheets("Data").range(C1:C11).printout
worksheets("Data").range(C1:C11).clearcontents

End Sub

»