Perhaps you want:

Range("C6").Select

(I haven't looked at the rest of the macro.)
--

Vasant

"Scott Zierler" <Scott wrote in message
...

ActiveCell.Select = ("$C$6")<<<ERRORS OUT HERE