Assuming here that iTargetR is an integer between 1 and 65536 and iTarDateC
is an integer between 1 and 256

Try just Cells(iTargetR, iTarDateC).Select


--
Rob van Gelder - http://www.vangelder.co.nz/excel


" Ralph Heidecke" wrote in message
news:%S0Gd.81947$8l.66029@pd7tw1no...
Can anyone tell me why:

Range(Cells(iNameR, iNameC + 3), Cells(iNameR, iNameC + iCount +
2)).Select

works while:

Range(Cells(iTargetR, iTarDateC)).Select

returns the runtime error '1004' method 'Range' of object '_Global'

TIA


--
remove 901 from reply email for valid address.


-----
remove