Turn on Learn Macro (Tools - Macro - Record New macro) and perform the steps
you normal do. Stop macro (Tools - Macro - Stop Recording). Then post code
on website.

"kathepoo" wrote:

I have 5 workbooks that i need to go to a sepcific worksheet do an
autofilter on a specific cell then coping and pasting that range into
a new work book.

If you could help I would appreciate it.

kat