Reply to thread

Message: [QUOTE="Jennifer, post: 6268653"] Thank you all for your suggestions. I did change the statement to Range("A1:F96"). Select but it didn't help. I'm still getting the 'Run-Time: Application-defined or object-defined error'. Still stumped, I tried to accomplish the same task another way, so now my code looks like this: Sheets("Items, Cat").Select ActiveSheet.Unprotect Password:="1234" Selection.AutoFilter Field:=1, Criteria1:="<>" Range("B3").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Now I get the 'Run-time: Selection method of Range class failed' error. Can you help again, please? Thanks in advance (again) - Jenn [/QUOTE]