How do I get this Macro I am working on to start at (A1) instead of (A2). I don't have a headed.
How do I get this Macro I am working on to start at (A1) instead of (A2). I don't have a headed.
Last edited by b_rianv; 09-13-2014 at 06:38 AM.
Never mind fixed my problem
When using Autofilter, the top row is not filtered. It's assumed to be the header row whether you have headers of not. There is no way to change that for the Autofilter function.
One possibility is to have the code insert a blank row at row 1 and then autofilter. At the end of the macro, delete the inserted row 1.
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.
ok thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks