the macro needs to check cells(1,1) and cells(1,2) if they are empty, i thought a code like this would be possible:
How do i make excel check the two cells in one if-then statement? or do i have to do multiple if-thens per cell?sub checkifblank () If Sheets("mcr analysis").Cells(1, 1).Value And Sheets("mcr analysis").Cells(1, 2).Value = 0 Then MsgBox "this is NOT working" End If
Bookmarks