Test To See Is Worksheet Variable Has Been Set Before Encountering Error

[Ark68]

I have a worksheet object defined as a worksheet ...

Dim ws_data as worksheet

Can anyone suggest a way to check to see is ws_data has been previously set.

I am getting an "Object variable or With block variable not set" error when my code reaches a point where ws_data isn't set.

 

[NoSparks]

This help at all ?

If ws_data Is Nothing Then
    MsgBox "ws_data needs to be set"
Else
    MsgBox "ws_data is set"
End If

 

[Ark68]

Hi NoSparks .... your solution is providing exactly what I need. Thanks!