Hello All,
I would like to take the value of any cell and be able to increase the value of each character by one.
I currently need this to work with letters only.
Here is my example... [azbycx] changes to [baczdy].
Thanks,
pmw
Hello All,
I would like to take the value of any cell and be able to increase the value of each character by one.
I currently need this to work with letters only.
Here is my example... [azbycx] changes to [baczdy].
Thanks,
pmw
Last edited by pimpmyworksheet; 07-14-2010 at 02:34 PM.
Hello pmw,
Welcome to the Forum!
Here is an example VBA macro to increment only letters. You didn't say how you plan to use this, so I couldn't customize it.
Please Login or Register to view this content.
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks so much for your help!
This is what I was looking for but as you said I didn't specify how I wanted to use it.
What I want to be able to do is select a cell(s) and run this macro and have it change the selected cell(s) to the output of this script.
So if I selected cell A1 and it's contents were "abc" and then ran this script on that selected cell it would change the contents to "bcd".
Thanks!
pmw
Hello ,
I revised the macro to operate on the active cell.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks