If "Blank" Don't Go On

[Littlemalky]

I'm using excel 2007 and relatively new to vba. I have data on one workbook entitled, "QryNewReleasesDomestic", and I'm trying to copy/paste the contents to another workbook entitled, "Domestic", worksheet name, "********".

However, if there is no data in cell "A2" on the QryNewReleasesDomestic workbook, then I don't want to copy/paste to the other workbook because there won't be anything to copy/paste. What I want it to do if that cell is blank is to move on to the next macro I have below it. If you need the name of that macro to call upon it, I can provide that.

 

[VoG]

Try like this

If Sheets("QryNewReleasesDomestic").Range("A2").Value = "" Then
    Call MyNextMacro
    Exit Sub
End If