Hopeagle
11-04-2011, 11:59 PM
I have a 2010 workbook with 114 worksheet with data by date. I need to filter and print worksheets 3 thru 114. the filter will be base on column A.
Example:ActiveSheet.Range("$A$1:$A$31").AutoFilter Field:=1, Criteria1:="4" how do Iget from sheet to sheet and print
Example:ActiveSheet.Range("$A$1:$A$31").AutoFilter Field:=1, Criteria1:="4" how do Iget from sheet to sheet and print