Look in http://www.ozgrid.com/VBA/MiscVBA.htm and go down to Print a Long
Column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cara" wrote in message
...
I have a column of Titles sorted alphabetically from position A2 down to
A293. I would like to put it on another worksheet so that it is covering
3
columns yet still be alphabetical, i.e.; A2=alpha, B2=bravo, C2=charlie,
A3=delta, B3=echo, C3=fox-trot, A4=golf, etc. I have tried sorting left
to
right, but it does nothing. Can someone please help?