ExcelBanter - Excel 2007 Range.Find method 255 character limit?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel 2007 Range.Find method 255 character limit? (https://www.excelbanter.com/excel-programming/433465-excel-2007-range-find-method-255-character-limit.html)

SysMod

Excel 2007 Range.Find method 255 character limit?

If I do a .Find with a What:=longer than 255 characters, it fails with a Run
time error 13 Type Mismatch

Is there a workaround in Excel 2007?

TIA
Patrik

All times are GMT +1. The time now is 08:24 AM.