Changing a colour scheme and extracting data from the internet

Sometimes I have a spreadsheet containing lots of spreadsheets of similar formats all using the same colour scheme. And if after a while I decide I don’t like the colours any more then it can be quite annoying to change all of the colours. So I decided to write this short little macro to change the colours.

I didn’t have a long spreadsheet to hand so I decided to create one using some of the Met office's data. They provide historical data for a number of their weather stations in text files all in similar formats. This spreadsheet opens each of web links, copies the data into a spreadsheet and puts it in a nice(ish) standardised format.