Just make sure you include the hidden columns in the sort range.

i.e.

Data in A through M

D through L are hidden.

Select A through M and DataSort.

The hidden columns will sort along with the others because sorting is being
done by rows.

Works the same with hidden rows if sorting left to right.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 11:59:11 -0700, "nanimadrina"
wrote:

I want to sort on a column of data (card #) where my worksheet has hidden
columns. I read in help that I should unhide the columns, but I am trying to
avoid that because it is a corporate worksheet and I have to copy/paste data
into it each month.

Is there any other way that I can accomplish a sort with hidden columns? I
have zero experience with macros...would a macro be able to sort data with
hidden columns in it?

HELP! I'm trying to find a way to save hundreds of hours/year in gas
receipt reconciliations...