Quote Originally Posted by Excel Fox View Post
From what I gather, is this what you are looking for

Code:
If Worksheets("Sheet2").Range("J4").Value = 0 Then
Call DeleteData
End If
The reason I hesitated in giving the OP an answer is I'm kind of sensing there is a loop iterating in FormatSheet and I wasn't sure if the If..Then you showed should be wrapped around the loop or embedded within it, hence my desire for more information.