How to Add a String to the beginning of every value in a range

Originally Posted by xlnitwit

Strictly speaking it would have been better to declare it as a Range. The code is equivalent to

For Each invoiceNameValue In invoiceNameRng.Cells

so it just loops through each cell in the specified range and amends it as required.

Didn't we declare it as a range at the top when we said:

Dim invoiceNameRng As Range