If startCell is a string, then that should work.

If it is a range object (which is the only way I could get your error) then you need to do this:

Set startCell = Worksheets(worksheetname).Cells(startCell.Row + 2, 1)

HTH,
Bernie
MS Excel MVP


"bjwade62" wrote in message
...

I have an Excel spreadsheet that gives me an Error 1004 Method 'Range'
of object '_Global' failed at the following line.

startCell = Worksheets(worksheetname).Cells(Range(startCell).R ow + 2,
1).Address

Can anyone help?

Thanks,
Bernie


--
bjwade62
------------------------------------------------------------------------
bjwade62's Profile: http://www.excelforum.com/member.php...o&userid=37186
View this thread: http://www.excelforum.com/showthread...hreadid=568955