I have to swap data from one spreadsheet and paste that information into my own spreadsheet. The problem is the surnames in the source document are in block capitals. I was wondering if there was a vba code that I could use to change this to Title Case once I activated it.
The surnames are stored in column B from Rows 7 to 100, it is possible for the macro to check only for the lines that are not blank as I don't need it checking every cell between B7 to B100 each and every time I run it? Although even if it does have to check the range B7 to B100 I guess it wouldn't take that long anyway?
Thanks in advance.