[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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