Finding special characters

[QuiksilverHg]

I'm trying to make a legend for a schedule-writer I'm making. I only want to put parts of the legend in if that character is actually used that day. So what I'm trying to do is search a range for a character and then if it is there add that to the legend.

The problem is what I'm searching for are special characters like ?, ^, ! etc.

I've been trying to use the find function like this:
sheets(1).Range("C27","AJ46").find(?)

It returns an error though when I use the ?, then if I try to put it in quotes "?" or make a string using cstr(?) it returns every cell as valid as if it's a wild. (the find function in excel seems to do the same thing)

So my question is how do I make it search for the character "?" (and other special characters) vice having excel use it as a wild?

 

[pgc01]

Hi

You use the tilde "~" to escape wild characters. In this case try finding "~?"