Visibledropdown false not hiding all arrows

**WasWodge** · 12-21-2010, 05:50 PM

I am probaly being a bit slow today (Feel it) but if anyone could look at the code below. I have put some code right at the end to hide the filter dropdown arrows, which is working to a point.
That "point" is column I but it is not removing the arrows after this point (See results sheet). If anyone can point out what stupid action I have (Or haven't) done to cause it to stop there I would be grateful.

Please Login or Register  to view this content.

**shg** · 12-21-2010, 06:01 PM

Why not replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

But, given that the dropdown is invisible and you aren't applying any criteria, what are you trying to do?

**WasWodge** · 12-21-2010, 06:34 PM

Shg, the sheet attached is a results sheet after the macro has run. Before the last part of the macro was run it had dropdowns from column A to R. After the macro runs it is removing the dropdowns from A to I but stopping there. I need it to remove all the dropdowns.
I have attached a copy of the text file so you can see exactly what happens.
i isn't defined in the last part but is earlier (which might be where the problem lies)

**shg** · 12-21-2010, 06:51 PM

It stops at col I because col J is blank (select A1 and do Ctrl+Right arrow).

**shg** · 12-21-2010, 07:00 PM

If you just want to turn AutoFilter off,

Please Login or Register  to view this content.

**WasWodge** · 12-21-2010, 07:15 PM

Cheers Shg. The autofilters need to stay on just needed hiding. Said I was being slow today. Thought I had done the code wrong and didn't think that it might be a problem with the spreadsheet itself. Thanks for giving your time on what turned out to be a minor and easily solved problem.