Hi Jd,

It looks like the way the Excel developers designed it is that, when you select the cells in that way, the first (visible) cell must have an error in it. The first, visible cell of the selection in this situation is the activecell.

So, if you select the whole of column H and if H1 has an error then it should be okay because H1 would be the activecell.

If H1 doesn't have an error value but H2 does, then hiding the whole of row 1 and then selecting the whole of column H should also do the trick because H2 would be the activecell.

Hope that helps...
Colin