"pwermuth" wrote in
message ...
Thank you for your responses.
I will try hardcoding the name.
How can I check what the value of a variable is once I am in debug
mode? I am completely new to VB.

There are several ways to do this. For simple variables, once you are in
break mode all you should need to do is hover your mouse cursor over the
variable whose value you want to see and a yellow popup window will appear
that displays its current value.

The most robust way to see the value of a variable is to select it with
your mouse, right-click and choose Add Watch from the menu. Click OK in the
resulting Add Watch dialog and the Watch window will open with your variable
displayed in it, along with its value, data type and watch context.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm