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


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





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---