Hi Mary,

What errors are you getting?

It may be that the code requires minor adaptation to suit your data, but you
would need to give details. With the active workbook being the workbook
holding the code, Ron's code worked for me.

---
Regards,
Norman



"mary" wrote in message
...
Thanks Chip. I want to be able to copy all columns and rows in each sheet.
It wil have information on column A:D and it rows. I check that site by
RON
DE BRUIN but i am getting errors.
Thanks in advance

"Chip" wrote:

which column do you want the alpha sort done on?