av8tordude
02-03-2013, 09:42 AM
I'm trying to check if a cell is empty. When I select the sheet from the combox, I get an error from the code below. Any ideas?
To check cell A1 is empty on a specific sheet, the combo box (cboYear) to select the sheet name. The combo box is on a userform.
Msgbox Sheets(cboYear).Range("A1") = ""
To check cell A1 is empty on a specific sheet, the combo box (cboYear) to select the sheet name. The combo box is on a userform.
Msgbox Sheets(cboYear).Range("A1") = ""