In Col A starting at cell A1 to A42 I have the numbers (years) 1963 to
2005.

I want to run a macro that will start at the beginning and assign a font
size of 1 to A1 and then 2 to A2 and so on until cell A42 where it finishes
with a font size of 42.

Can anyone help?

TIA, Alan