Hi all,
I have inherited a spreadsheet with VBA code that dynamically creates a string from various bits of dynamic text scattered around the workbook. Sometimes though it ends the constructed sentence with a comma and I need it to remove this if this is the case. Pseudo-code would be
1) Create string (this bit works okay)
2) Check last character - is it a comma?
3) If so remove last character, else do nothing
I've tried various approaches but can't get it to work. Anyone got any suggestions???
Thanks
Bookmarks