Thanks xld - your reply got me looking at things outside the code. Column D is hidden and the sheet is protected - when I unprotected the sheet and had unhidden column D it worked fine!!

Cheers,
rrenis