Help finding the last cell in a range.

[Bob Phillips]

In Excel: I have a group of columns. Row 2 has Q1, Q2, Q3, Q4 repeated for each year that is in row 1, the four cells in row 1 are merged and hold the year.

Don't use merge cells, they are more trouble than they warrant.

Use Format>Cells>Alignmnet Centre Across Selection instead.

I can find the beginning of this range using the MATCH function (thanks again xld), but not the end of the range, unless I know the last cell of the range.

iLastCol = Cells(2, Columns.Count).End(xlToLeft).Column

Right now I am setting the range in my MATCH to A2:IT2 to find the last Q4, which is my fix for now, but I would love to know a way to do this (actually, a way to find the end of a row or column instead of a Do Until...Loop = "" or a SendKeys "^{Down}" would really be great).

I would just use

Application.MATCH(value,Range("2:2"),0)

that is test the whole row. It is only 256 cells so there is no great problem.