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