Search Code Locking Column

[LewisJ]

Hello,

I have this code to search the workbook when entering text or amount in cell N4. It searches and lists all occurrences that match fine when the workbook is unprotected. I set the column 'P' to be unlocked but when running a search it locks the column cells and results in debug when running it again.

Can someone please see if there is a way to keep column 'P' cells from being locked?

Thank you,
Joe

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Replace .Clear with .ClearContents (or .Value = vbNullString)

[LewisJ]

Thank you for the reply. Just to be sure what would be the whole code change?

[xlnitwit]

Please Login or Register  to view this content.

I also added some code to prevent recursion due to changing cells inside a change event.

[LewisJ]

I replaced the code but no results are found now.

Can you take a look please?

[xlnitwit]

Your input cell is N3 and not N4 which is why the code is not doing anything.

[LewisJ]

So sorry for the trouble. I am storing this file on OneDrive and did updates at home this morning. For some reason those changes didn't come through on my work computer. I will have to look into this today.

Thanks for the great help!