Hi Parteegolfer,

I suspect that your reply was intended for Duane rather than me.

Try, however, adding a closing parenthesis:

Range(Cells(10, 1), Cells(myrow, 1)).Select

---
Regards,
Norman



"parteegolfer"
wrote in message
news:parteegolfer.25eynm_1143606301.3951@excelforu m-nospam.com...

Sorry its a Syntax error

Range(cells(10,1),cells(myrow,1).select


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=527414