HELP - Button to clear content in a cell range

[mauricelopes]

i need a button to clear content in a cell range: G15:197 and J15:197

 

[SteveO59L]

Range("g15:g197").ClearContents
Range("j15:j197").ClearContents

 

[mauricelopes]

how do i install this (im new to the macro thing)

 

[SteveO59L]

Create your button from the Forms toolbar.

In design mode, selct the button, right click and select the view code option.

Then paste the two lines between the Sub/End Sub

 

[Peter_SSs]

Not a big deal, but you could do both ranges in one go:

Range("G15:G197,J15:J197").ClearContents

 

[Peter_SSs]

Create your button from the Forms toolbar.

In design mode, selct the button, right click and select the view code option.

Then paste the two lines between the Sub/End Sub

Forms toolbar or Control Toolbox?

 

[mauricelopes]

im new at this, i just aded the following, can i add the button to clear in the same macro ? if so can you please tell me how, thanks.

Sub try()
x = 15
Do Until x = 198
If Cells(x, 6) = 0 And Cells(x, 7) = 0 Then
Rows(x).Hidden = True
End If
x = x + 1
Loop
End Sub

Sub undotry()
Rows("15:197").Hidden = False
End Sub

 

[SteveO59L]

Peter, you are correct. I should have said the Controls Toolbox

 

[Peter_SSs]

i just aded the following, can i add the button to clear in the same macro?

I'm not sure just what you are asking, as you actually have two macros. Can you explain in a bit more detail just what you are trying to do?