Macro for button to delete specific worksheet rows and columns

**unclejemima** · 02-22-2018, 07:41 PM

I'm looking for a macro on worksheet 1 to delete all contents from worksheet 2 in range A2:H10000

Can someone get me a macro code to do this?

**munuelitu** · 02-22-2018, 08:03 PM

Please Login or Register  to view this content.

if you want to eliminate the range and shift up the bottom ones to kill colors and borders too:

Please Login or Register  to view this content.

**unclejemima** · 02-23-2018, 01:21 PM

I'd have to put a Sub Clear () and End Sub at the front/end of this right?

**unclejemima** · 02-23-2018, 01:57 PM

works like a charm now with the sub and end sub. (I'm a noob lol)

**munuelitu** · 02-23-2018, 02:06 PM

Originally Posted by unclejemima

works like a charm now with the sub and end sub. (I'm a noob lol)

Yes of course, I just posted the core of the sub....

Well done figuring it out!

Re: Macro for button to delete specific worksheet rows and columns