I have this function:
[vba]
Public Sub Check_Null()
Dim Rng As Range
Dim wb As Workbook

Set Rng = Range("A2:A3")

If IsNull(Rng) = True Then
wb.Close
Else
wb.SaveAs FileName:="Location & FileName"
End If
End Sub
[/vba]
Which I am trying to use if cells A2 and A3 are Null, then close the workbook, there's no point in saving. However, if there is data in A2 and A3 then I want to save the workbook.

Problem I am having is it is closing the workbook regardless if there is data in A2 and A3. It just closes the workbook regardless!

This may be pertinent may not be, A2 and A3 hold numbers for data.