Using Select with Range.Cells property
 

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

Using Select with Range.Cells property
 

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

Using Select with Range.Cells property
 

Range can not take a single range object as an argument. Range(Range1) is
not legal syntax. Range(Range1,Range2) is. (Rangex represents a range
object).

--
Regards,
Tom Ogilvy
" 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