I'm not sure what you mean by "a string value being null". A variable
declared As String can be empty (unassigned), a vbNullString, or empty
string "", technically not quite the same but for most practical purposes
can be regarded as such and confirmed with -

Len(myString) = 0

A String cannot contain a Null value which can only be assigned to a
Variant. However trying to assign Null to a string would indeed raise an
error (94 probably) but would not change any existing string value.

You would need to roll your own function to return values of your strings.

Regards,
Peter T


"cereldine" wrote in
message ...

Hi i'm trying to improve an error handler that i'm putting together. I
have a case statement based on an error number. If the error is due to
a string value being null i would like to list all strings in a message
box or something and show all the values?

My question is whether there is a function that will state all strings
being used at that time and their particular value? My code is
relativly long and this would help with debugging Thanks


--
cereldine
------------------------------------------------------------------------
cereldine's Profile:
http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=554916