Hi, i'm new in this forum.
Currently, i'm facing difficulties with this macro. I need this code to work in all other 8 sheets.
I would appreciate if someone could re-write a new macro code for me. Thanks!
Please Login or Register to view this content.
Last edited by Leith Ross; 01-25-2017 at 10:51 PM. Reason: Added Code Tags
Hello CloiudXiang,
Welcome to the forum!
The code as written should work with any sheet in your workbook. What difficulties are you having?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
The code can only work when the table of abbreviation and replacement are placed together in column A and B of a specified sheet.
Other sheets that does not have that particular table, the code cannot be applied.
I would like the code to be stored in just one sheet and applied across all the other 7 sheets i'm working with.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks