Sometimes Excel cannot find text in a cell that is clearly visible. Some workarounds and solutions:
- In the "Find and Replace" dialog, untick "Match entire cell contents".
- In VBA, specify the LookAt parameter, .Find(..., lookat:=XlLookAt.xlPart)
- In your worksheet, remove custom formatting from the cell range you are searching.
The last workaround is pretty weird. One would think that formatting shouldn't affect searching for data!
No comments:
Post a Comment