I tried the below but received a syntax error when I ran it. Do you know whatcould be causing it? I'm working in Excel 2000 and am not sure if I'm applyingthe macro correctly.