AutoFilter does not work after the 255th character

gbja7

New Member
Joined
Jan 18, 2005
Messages
2
I have been working on a rather large project and have pretty much gotten everything automated by scripting. However, I found that my autofilter is not catching everything because the criteria it is searching for is after the 255th character.

Find recognizes the string when I do it manually but I cannot seem to get the method to work in vbscript. I must be using the wrong syntax or not declaring something.

Any workarounds for this?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

gbja7

New Member
Joined
Jan 18, 2005
Messages
2
Ken,

Just wanted to tell you thanks. It was the information autofilter was missing that I needed the most before the fix. The link helped considerably as well as provide other useful advise.

Brad
 

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267
You're welcome. Debra's site has some great stuff on pivot tables if you use those at all. :)
 

Forum statistics

Threads
1,147,507
Messages
5,741,566
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top