How to clear contents

Closed
Alan M
Posts
3
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
March 26, 2014
- Mar 26, 2014 at 07:12 AM
 Blocked Profile - Mar 26, 2014 at 07:31 PM
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.

4 replies

SANBOOLY
Posts
9
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
August 21, 2015

Mar 26, 2014 at 09:40 AM
could you please Provide the Example Sheet to more clarify ?
0
Alan M
Posts
3
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
March 26, 2014

Mar 26, 2014 at 12:45 PM
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
0
Blocked Profile
Mar 26, 2014 at 05:01 PM
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!
0
Blocked Profile
Mar 26, 2014 at 05:02 PM
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/26/2014 by desktopuser'

'
Range("B2:H13").Select
Selection.ClearContents
End Sub
0
Alan M
Posts
3
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
March 26, 2014

Mar 26, 2014 at 06:17 PM
Thank you for your replying, I got it to work :-) easier than I thought. Thanks again.
0
Blocked Profile
Mar 26, 2014 at 07:31 PM
IS it solved?

I am glad to help!

Always, Have fun!
0