I must say also that I never have any probs with Public Variable loosing there value unless the Workbook is close.

LLoyd, if you do not have any "End" Statements and you are using the Public Statement, the only other thing I can think of is you may not be doing this in a Standard Module! Perhaps you are doing so in a Private Module (UserFor, Workbook, Worksheet)?