View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SysMod SysMod is offline
external usenet poster
 
Posts: 21
Default 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