Simple.
Code:For j = 13 To 24 If Me("Checkbox" & j) Then Sheets("Schedule").Range(Choose(j-12, "sep_pay", "oct_pay", "nov_pay", "dec_pay", _ "jan_pay", "feb_pay", "mar_pay", "apr_pay", "may_pay", "jun_pay", "jul_pay", "aug_pay")).ClearContents Next
Simple.
Code:For j = 13 To 24 If Me("Checkbox" & j) Then Sheets("Schedule").Range(Choose(j-12, "sep_pay", "oct_pay", "nov_pay", "dec_pay", _ "jan_pay", "feb_pay", "mar_pay", "apr_pay", "may_pay", "jun_pay", "jul_pay", "aug_pay")).ClearContents Next
Bookmarks