Running macro in multiple sheets

Hi,

I have the following code to run an autofilter in multiple worksheets. The worksheets aren't consecutive, so I want to be able to name exactly what sheets I want the macro to run in, I will ultimately be naming alot more. Here is what I have so far:

Please Login or Register  to view this content.

The first line where I specify the sheets is not working. Thanks for any help

shak1

try......

Please Login or Register  to view this content.

The first code dosent look right

Please Login or Register  to view this content.

looks correct

I am now getting a "Compile Error End With without With".

Please Login or Register  to view this content.

Please Login or Register  to view this content.

will have it

Your right


use

Please Login or Register  to view this content.

I've tested this code and it will do s you require

if there is no data in the selected sheet or range it will error

check to see if you have data in sheeets 13 and 15 in the ranges

Please Login or Register  to view this content.

added

Please Login or Register  to view this content.

so that if there is no data it moves on
also are your sheets naamed "Sheet13" and "Sheet15"?

Will try that new advice, Thanks