Search Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3027416%22%20slang%3D%22en-US%22%3ESearch%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3027416%22%20slang%3D%22en-US%22%3E%3CP%3EI%20searched%20for%20a%20word%20%26amp%3B%20deleted%20the%20row%20containing%20that%20word.%20Then%20I%20search%20for%20another%20word%2C%20I%20get%20the%20result%20as%20not%20found%20whereas%20I%20can%20see%20that%20word%20when%20I%20browse%20this%20sheet.%20If%20I%20undo%20the%20delete%20action%2C%20I%20can%20find%20the%20other%20word%20which%20was%20declared%20as%20not%20found.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3027416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I searched for a word & deleted the row containing that word. Then I search for another word, I get the result as not found whereas I can see that word when I browse this sheet. If I undo the delete action, I can find the other word which was declared as not found.

2 Replies

HIi @aredev 

 

when you delete a complete row, after the deletion the next row is already selected. If you do now your search, then this search gets only done within the selection, which is jus one row.

 

In other words, you just need to make sure no cells are selected before you start the next search.

Hi @DTE, Thanks for helping me. I knew the solution but somehow I was confused because of some other challenges while working with Excel.

Thanks once again.

Warm regards,

Rahul Dev