Hi Nike,

What do you meant by dim another variable under strX?

When a variable is dim as public, although it can be called through out
the project, but once the program is terminated (with the workbook
still remaining open), the variable got destroyed. So just dim the
variable as public is not good enough.

May be I should make a new post on this question.

- Excel 009