Help finding the last cell in a range.

[wnazzaro]

I don't think I am getting this.

If I have say Q1 in H2, L2, P2, etc., if I do a Application.MATCH("Q1"),Range("2:2"),1) I get the last one fine. So where is the porblem that you have?

Other than that you can use

Application.MATCH("Q1",Range("A2",Cells(2,iLastCol)),1)

as I showed earlier.

Try this: put Q1 in H2, L2, P2, and T2 and do the Match. I get 16, not 20 like you would expect.