You need to define the variable as global. Write in the beginning of th
module you define it as

Dim Var1

- Manges

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