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