Hey guys not only am I new to this forum but new to the world of Macros in General.
I'm trying to make a set of letters represent a numerical value (ex:xoxoxo = 0.547) but I want to put the numerical value generated in the cell to the immediate right.
I Wrote the code
Cells.replace What:="xoxoxo", Replacement:="0.547", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
using bits and pieces from around the internet and it worked to replace the letters with the numerical value but I need the numerical value to go next to the letters in the cell to the immediate right, not replace it as I had written.
Any help of any kind would be much appreciated.
And again I must stress how new I am to this,
Bookmarks