Hello

Instead of

Range("d2:g40").Select

I would rather use the r1c1 format because it is easier to use integers to
define the range. Help seems to imply that only A1 notation is available
which I cannot believe would be true.

How might I do it?

Thanks

W

instead of using strings...
why dont you set them directly:

with activesheet
.Cells(x,y).Resize(h,w)
or
.Rows(x).Resize(h)
or
.Columns(y).Resize(,w)






keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"verizon" wrote:

Hello

Instead of

Range("d2:g40").Select

I would rather use the r1c1 format because it is easier to use
integers to define the range. Help seems to imply that only A1
notation is available which I cannot believe would be true.

How might I do it?

Thanks

W

Range("d2:g40").Select

In r1c1 this would be

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

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

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/

Sorry... you're right.... should be a comm

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