Hi,
I just started learning VBA yesterday and don't have much knowledge. How do you write codes to check whether a cell is blank or not? If it does have a blank, it will throw out an error message.
Hi,
I just started learning VBA yesterday and don't have much knowledge. How do you write codes to check whether a cell is blank or not? If it does have a blank, it will throw out an error message.
[VBA]If (IsEmpty(Cells(1, 2))) Then
MsgBox "1"
Else
MsgBox "2"
End If[/VBA]
I am a Newbie, soon to be a Guru
Thanks appreciate it.
Or commonly
[VBA]If Cells(1,1) = "" Then[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
