I would like to perform the following action on all the cells of the current column (one cell is activated in the current column)
1. Prompt the user to enter a file extension in an inputbox (only characters are allowed, no numbers)
2. Add this extension to all the values in the current column
For example: User enters '.pdf' in the inputbox
Current Column Current Column after running the macro
Help is much appreciated. Thank you very much in advance.