Hi all,

I have a requirement in VBA to enter a formula into the first blank row on column W. The formula is this: “=IF(V1=0/1/1900,"",MONTH(V1))”

However instead of the formula referring to ‘V1’I need it to refer to whatever the first blank row is on column V.

The reference to V? needs to be relative as then I need VBA to autofill the formula to the last non-blank row in column A.

Any ideas?