Assistance with running 2 macros on 1 sheet. Code included! 2 buttons on sheet to link.

well I got it too. and more than likely that's because you have moved the workbook to a location that is NOT what you have in the macro pointer location you specified when you created the macro. it currently is:

'C:\Users\Chris\Desktop\Family Organization\W Family Groceries test.xlsx'!Clearcells

when you create a macro with the dialog, (right clicking on the button, etc, etc.... and pushing ""assign macro""), you have many options. (this book only, all books, etc, etc....). I'm obviously getting the error because I do not have dir architecture like yours.

Originally Posted by superCWdad

There are 2 buttons I made one for clear range of cells and one for fill blank cells with 0.

You only have 1 button named "Clear Sheet" on "Data" sheet.
If you have 2 buttons then assign following 2 macros respectively.

Sub ClearcellContent()
    Range("D3:D30,D32:D40,D42:D60,J3:J30,J32:J40,J42:J60").ClearContents
End Sub

Sub ReplaceBlankswithZero()
    On Error Resume Next
    Range("D3:D30,D32:D40,D42:D60,J3:J30,J32:J40,J42:J60").SpecialCells(4).Value = 0
    On Error GoTo 0
End Sub

Thank you for the responses, I have been swamped and will try out the solutions tomorrow and post the results. Thank you!

I decided to only use the Clear Content macro thank you for the replies and assistance!