Simple range reference question?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi.

I am struggling with how to refer to a range by using
column and row numbers.

I have an integer variable, myColumn, that stores the
column number I would like to start from and endRow, an
integer variable that stores the last row. I would like
the range to start from Row1, mycolumn to row endRow, and
4 columns to the right of myColumn.

Can someone help me complete the myRange statment:

set myRange =

Thanks,
Mike.
 
Range(Cells(1,myColumn),Cells(endRow,myColumn))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks, Bob!

-----Original Message-----
Range(Cells(1,myColumn),Cells(endRow,myColumn))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Set rng=range("A1")
set myRange=Range(rng(1,myColumn),rng(endRow, myColumn+4)

Alan Beban
 
Back
Top