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 th
end of the set statements.. can't find anywhere in the help that give
me an indication what those parameters are for.


Thanks in advance,
Stev

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

The (2) refers to row 2 and of the current range.

(1,2) refers to row 1, column 2 of the current range.

The other code is creating a range from a certain point (A3 or A1), and
finding some end point, and then setting the range object to part of the
found range.

--

HTH

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

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

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