Why aren't you using the sheet1_selection_change or sheet1_change event ?

Charlize