Code - finding null

How can I add to this for Sheet 4 where column AP is null??

Dim c As Integer, i As Long
 ClearSheet "CU_tmp", 2
 i = Sheet4.UsedRange.Rows.Count
 c = FindCol("Compare", 2, "Security CUSIP")
  If i > 65000 Then i = 2
  Sheet4.Range("A3").Offset(0, c).Resize(i, 1).Copy
  Sheet19.Range("A3").PasteSpecial xlPasteValues
  Application.CutCopyMode = False
leezacAsked:
Who is Participating?
 
rspahitzConnect With a Mentor Commented:
Are you looking for something like this:

If Range("AP1").Value = Empty Or Range("AP1").Value = "" Then

Open in new window

0
 
Shanan212Commented:
Do you want make sure that all rows in column AP are null? Could you explain please?
0
 
leezacAuthor Commented:
Are empty - no values in AP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.