Re: Add .jpg to all cells
Assuming your data is in column A from A1 downwards:
‘ AmendCell Macro
‘ Set Do loop to stop when an empty cell is reached.
Do Until IsEmpty(ActiveCell)
ActiveCell.Value = ActiveCell.Value & “.jpg”
Edit “Range(A1).Select” to suit your spreadsheet