Calculate formula in VBA instead of formula in workbook

[Jessica.Bush]

Hi all,

Just a small but annoying query.

I have a column of dates and to the right their week number using the formula =weeknum(rc[-1],2). Ideally these week numbers would be values rather than a formula and I am able to use VBA to enter the formula and then copy and paste the answers as values.

My query is whether I could get the calculations to work in VBA so that the values go directly in to the workbook or whether I need to do what I am currently doing.

My current code is below to enter the formulas.

Many thanks for you time and help

Please Login or Register  to view this content.

[teylyn]

You could use

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[Jessica.Bush]

Thank you both!