Then you need to define the variable...


Dim res As String

or

Dim res As Variant

You usually get that error when you have "Option Explicit" at the top of
your module. It's a GOOD thing. Keeps you from tearing your hair out
over thing like:

Dim result As String

'lots of code here

res = Inputbox("...")

'lots more code

If result = "foo" Then
'...

where result never gets assigned...

In article ,
"Corey" wrote:

The Compile error says:
Variable Not Defined?
I removed the Spaces but they return and the same error occurs.