Try this,
Modify for your range of cells as noted.![]()
Sub Reset() Range("A1").Select ActiveCell.FormulaR1C1 = "0" Selection.AutoFill Destination:=Range("A1:A36"), Type:=xlFillDefault 'Modify above for your range of 36 cells End Sub
Try this,
Modify for your range of cells as noted.![]()
Sub Reset() Range("A1").Select ActiveCell.FormulaR1C1 = "0" Selection.AutoFill Destination:=Range("A1:A36"), Type:=xlFillDefault 'Modify above for your range of 36 cells End Sub
SPARTAN
Please click the * if my solution helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks