How to clear contents Closed

Question

Hello, 

I would like to know how to clear cells from a banking sheet with 7 tills, range from B5/B16 D5/D16 and 10 other columns. I'm hoping if I can learn to do the first rows  I can work out to do rest. Any help would be appreciated.

SANBOOLY · Answer

could you please Provide the Example Sheet to more clarify ?

Alan M · Answer

Hi, I'm probably being dumb but can't see a way to attach the sheet.  I'm looking to create a button that clears a range of cells, lets say I had 2 columns  B5 to B16 and D5 to D16, How would I do that :-) Many Thanks

ac3mark · Answer

OK ALAN, hang in there.  I am going to record a macro, and post it here.  Make certain you understand how to chnge the range to what ever value you wish.  All that I am going to do is, record a macro, and cut and paste it.  I hope you know how and where to attach the code to the button.

Have FUN!

Alan M · Answer

Thank you for your replying, I got it to work :-) easier than I thought. Thanks again.

How to clear contents

4 responses

Similar discussions

Subscribe To Our Newsletter!