I have a work book where on one page, "Display", I want to search columns I,K,M and O for a numeric ZERO 0 value and when found paste "NA" in the cell immediately to the right. I can not seem to get the VB code for a macro nailed down. Any help would be appreciated.
I want it to search from row 5 to bottom of work book in each row.
Thank you in advance.
Last edited by dzas1632; 07-31-2021 at 03:07 PM. Reason: I have Office 365
Welcome to the forum.
10 is not an MS Office version - please update your profile. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks