• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

Checking to see if range is blank

Folks,
I need to check to see if in the range D7:D14 is blank to exit my sub. This did not work.
If Range("D7:D14").Value = "" Then
Exit Sub
End If

Open in new window

0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
duttcomCommented:
You could try using the countA function -

If WorksheetFunction.CountA(Range("D7:D14")) = 0 Then
Exit Sub
End If
0
 
Frank FreeseAuthor Commented:
Ok....that'll work. Thanks
0
 
Frank FreeseAuthor Commented:
thank you
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now