Thread: Help to spead up macro - Find and Replace in Tables, Cut Paste Next Cells
View Single Post
 
Old 08-20-2019, 11:28 AM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Cendrinne,


The code yesterday only worked if the $ symbol was in front of the amount. So, if you have $10 is worked 10$ it wouldn't. Same for %10 and 10%. The code today works regardless which side of the amount the symbol is located.

I develop solutions with VBA (mainly Word) and charge a fee. Contact me via my website if you wish. I've never done a course.

My website has a bit of background on me.


Thanks and it should work going forward.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote