I'm unable to sort a range of cells within hidden rows of cells. My macro
works when i unhide the cells.

e.g.
Rows 1 to 15 are hidden, range B2 to B12 are sorted