Hi and thanks in advance for any help with this! I've got a problem which I'm sure is fairly basic to solve but I can't seem to find the solution.I have a table (Table1) which has various columns. I'd like to use VBA to capitalise 3 of the columns (Surname, Gender...