The file is a download and some of the cells are formatted to text. So I have built a macro to make various changes and this is the last part - I have to put calculations in various cells on the worksheet.

SendKeys was recommended to me years ago as a way to write F2 Enter into a macro. I have hardly ever used it but the one time I come to use it it won't work.

I wasn't aware it was a bad idea and not recommended.

Can you suggest something else?