Hello. I'm writing this code (I've just pasted the end of it) and it's all going well until the end. I just want to autofilter range A16 to O21 and have the filter be on A16. I'm getting an error saying subscript out of range. Why is this? Can you correct? Thanks.
Please Login or Register to view this content.
You have a typo. The 0 is a zero and not the letter O
Range("A16:021").Select
Or better yet.
Please Login or Register to view this content.
Last edited by AlphaFrog; 07-22-2013 at 01:57 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
You are missing a space
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks