14 Feb Macro add commas to each cell
Excel macros are my new favorite thing, I lie they have been really useful for years and it is only lately I have started to blog the ones I use every day. Today’s task is getting a list of keywords ready to parse to code, by adding a comma to the end of a long spread sheet of values 🙂
The Macro Code – AddCommaAfter()
Dim cell As Range
For Each cell In Selection
If cell.Value <> "" Then
cell.Value = cell.Value & ","
Else: cell.Value = cell.Value