Set myRange = Range(Cells(1, myColumn), Cells(endRow,
myColumn + 4))

HTH.

-Brad

-----Original 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.

.