Hello! I am trying to write a macro that will delete the entire workbook from my desktop if both sheets "100" and "MISC" have no data.
I keep getting a runtime error on the "Kill wb" line. Any thoughts?
Sub Macro1()
Dim wb As Workbook
Dim Test100 As Object
Dim TestMISC As Object
Set wb =...