Select Range using R1C1

  • Thread starter Thread starter verizon
  • Start date Start date
V

verizon

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 >
 
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))
 
Back
Top