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