Toppers...long time no see!
I'm glad to know that the code worked, and that I could help Eric; even
if by proxy.

See ya' around,
Amber


Toppers Wrote:
Amber,
I tried Tom's code (on Eric's "problem" that you replied to)
and it worked fine so this suggests a typo on your part.

Res will default to variant if you don't DIM it ( and I didn't).

"Amber_D_Laws" wrote:


I tried defining as:

Dim res As String
and
Dim res As Variant

both return the following error:

"Run-time error '1004':
Method 'Range' of object '_Global' failed

I'm I doing something wrong, or does the code contain a typo?

Amber :)

Amber_D_Laws Wrote:
Great! However, I need to how to define the varible "res"


--
Amber_D_Laws

------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread:
http://www.excelforum.com/showthread...hreadid=513312




--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=513312