I still can't figure out how to create a macro that will sort the same
information in the same way on multiple sheets in the entire workbook.
Possibly because I can't figure out how to select the whole workbook.

RichardVisteon" wrote:

I thought i'd try the hard questions first.

Thanks Tom.

Regards

Richard.

"Tom Ogilvy" wrote:

Cells.Sort Key1:=Range("A1")

--
Regards,
Tom Ogilvy


"tony h" wrote:


need a bit of imagination to answer this one


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=523054