[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

VBA to Check if Range is Set?

Hi All,

I thought this would be simple... ya, I think that a lot!
If rng = Nothing Then
Debug.Print "No-thing"
Else
Debug.Print "A-thing"
End If

Open in new window


I just want know if the range = Nothing. When I hover over the range it says rng = Nothing but I don't know how to get this information via VBA.

Thanks in advance!
0
DrTribos
Asked:
DrTribos
1 Solution
 
GrahamSkanRetiredCommented:
I thought"that looks like one of Steve's"

Dim rng As Range

If rng Is Nothing Then
Debug.Print "No-thing"
Else
Debug.Print "A-thing"
End If

Open in new window

0
 
DrTribosAuthor Commented:
Doh! it's an IS?  wow!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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