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)

"Mike" wrote in message
...
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.