Your code worked fine for me in Excel 2003 as long as I had a worksheet
literally named "sheetname" in the active workbook, and variables Row and
Col were assigned legitimate values. If "sheetname" is a variable rather
than a constant remove the quotes around it.

--
Jim Rech
Excel MVP