Looks like a small typo.
As written that would raise an error. The colon should be a comma:

Range(cells(2,4),cells(40,7))

--
Regards,
Tom Ogilvy

"Berend Botje " wrote in
message ...
Range("d2:g40").Select

In r1c1 this would be

Range(cells(2,4):cells(40,7))


---
Message posted from http://www.ExcelForum.com/