Check if data exist in Cell

[k3vsmith]

I have a macro that is run against a workbook that has 4 worksheets. Each worksheet has a header line on row 1. Row 2 is where data begins. Macro works when there is data in each of the worksheets on row 2. But if there isnt any data on one of the worksheets on row 2 its causing an issue further down the line in the macro.

Id like to know if I can do something where it checks if any data is in A2:

If NO data exist in A2 then
skip
Else
...continue to next steps in macro
End If

Data in A2 could be any. Not looking for specific data. Just that data exists there.

 

[YasserKhalil]

May be

If Not IsEmpty(Range("A1")) Then
    'Your Code
End If

 

[k3vsmith]

Thank you!

 

[YasserKhalil]

You're welcome
Glad I can offer some help

 

[Hui]

I use

If Len([A1]) > 0 Then
'Your code
End If