converting formula into macro

A have a huge formula (3 lines), which is repeated in ten-thousands of cells, so I would like to convert it into a macro function to make my file "lighter". Is there any way of doing this automatically? (as I have no experience with Visual Basic)

Thanks
Danny