For your reading pleasure. It's by Alan Beban on Chip Pearson's web site:

http://www.cpearson.com/excel/cells.htm

It might help understand some addressing techniques.

"stevem <" wrote:

Set Rng = Worksheets("Sheet1").Range("A3").End(xlDown)(2)
Set rng1 = Worksheets("Sheet2").Range("A1").End(xlToRight)(1, 2)

Ok, I understand all of this except what the (2) or the (1,2) do at the
end of the set statements.. can't find anywhere in the help that gives
me an indication what those parameters are for.

Thanks in advance,
Steve

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson