clear button
View Toolbars Forms
click on the button icon and put a button on the worksheet. When the Assign
Macro dialog box appears, select new and enter:
Sub Button1_Click()
Range("F6:G22", "K6:K17").Clear
End Sub
--
Gary''s Student - gsnu200770
"YMC" wrote:
Is it possible to make a button clear certain cells. i want a button that
will clear F6:G22 and K6:K17
i am not to sure how to put together the code. could someone please give me
an example? thankyou
|