You should have been able to figure out a typo and correct but you asked
=====
Dim i As Long
Dim mr As String
Do you mean Dim myvalue as String?
======
I answered "YES"
=======
Is there some part of this that is difficult to understand?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaybird" wrote in message
...
I'm sorry. "Yes" to what?

As near as I can tell, the "myvalue" statement is being rejected
because it hasn't been declared properly. I've attempted to declare
it as a string, an integer, and a variant without success. I'm not
sure what type of data type it is in this context.

Thanks for the help, by the way!