|Adding information to a spreadsheet, word document etc is one thing but most of the time you will need to add some formatting.|
You can add a Tab character in your VBA code by using one of the following :
phoneDets = “Phone number : “ & Chr(9) & Chr(9) & “07896541243”
This code is assigning the string ‘Phone number :’ with two tabs inbetween and then the actual phone number.
So the output will be :
Phone number 07896541243.