Thank you both for the help.
Unfortunately, I am new to macros and can't seem to get either option to work. I am sure I am doing something wrong.
I'm clicking on macros and then copying and pasting your code exactly as written into a Microsoft Visual Basic for Applications box.
Then I am selecting all the cells in my Excel sheet and choosing to run the macro. I am then seeing an error "Cannot run visual Basic Macro due to a syntax error"
What am I doing wrong?
Again, thanks so much for the help.