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

On Jul 28, 5:36*pm, Celiowin
wrote:
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

Unhide your data with your macro, sort the cells, then hide the range.
Though with 15 hidden rows and only B2 to B12 to be sorted, you are
sorting the hidden data.


Steven