On way is to *copy* the visible cells to another location, and then sort the
copy.
Select the cells in question, then hit <F5>,
Click "Special",
Click "VisibleCellsOnly",
<OK>
Now, right click in the selection, and choose "Copy",
Navigate to a section of the sheet where there are *no* hidden rows, and
then simply "Paste" and sort on the copied cells.
If you wish to do this often, there is a "SelectVisibleCells" icon that you
can place on your toolbar.
Right click on the toolbar, and choose "Customize".
Under the "Commands" tab, click "Edit" in the left window,
And then scroll down almost to the bottom of the right window to the
"SelectVisibleCells" icon.
Click and drag it to your toolbar.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
is there anyway using grouping i can do a sort ignoring the hidden rows?
example:
Rows hidden 1:12, 52:71, 111:130, 170:189, 229:236
Rows Visible 13:51, 72:110, 131:169, 190:228
Many thanks,
Steve
