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

‹ Create a Macro that will delete a cell range on print Using formulae to automate cell referencing ›
»

create a macro that will delete a cell range on print

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

Dear Rob.Surina,

You want that that once your print task is over the entire range values to be cleared.If I am correct ??

Sub Clear_Cells()

worksheet ("Data").range("C1:C11").printout
worksheet ("Data").range("C1:C11").clear contents

End Sub

»