Hi BSchwerdt,

I think you have to know where is the point at issue.
First I reccomend to add "Option Explicit" at the beginning of your
code.
And run your code with [F8] key (step by step)
See the value of the variables at the Local window in VBE.

PLEASE NOTE: Public variables should be placed in a standard module,
NOT thisWorkbook module.


---
Message posted from http://www.ExcelForum.com/