Macro that searches whole workbook and highlights cell
Hi,
I have a spreadsheet which is going to be used through out a company. It's contains 14/15 sheets.
I need the ability to search throughout the whole workbook with a simple ctrl & (letter) click and once it has found the selected cell it highlights it so that it stands out on the sheet?
I'm new to macros so would need talking through how to insert it onto the sheet. If you need more information please let me know.
Thank you
Can no one help?
Welcome to the forum. Please take a few minutes and read our rules and guidelines. There is a link at the top of this page. You will note that forum courtesy expects you to wait at least 24 hours before bumping your thread. It is important to have patience in the forums as not everyone lives in your time zone. This is an international forum with participants from all parts of the world. Not everyone is on your schedule. We all have lives and participate here as volunteers when and if we have time and the notion and most important the experience and understanding to answer your question.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks