Macro returns expected result

Hi Everyone,

I hope you are all well.

I have a formula

Formula:

Please Login or Register  to view this content.

I know that this works when I type it into the cell.

The problem is, I want a macro to type it in for me so I can hit a button, it types the formula in and copies it down the list. Here is my macro:-

Please Login or Register  to view this content.

The macro, however, does not work. When I look at what has been entered in is this

Formula:

Please Login or Register  to view this content.

(Note the 'A2' rather than A2 and the BB) rather than B:B)

Can anyone offer a solution or explain where Im going wrong?

Thanks for your help
Alex

looks like the title has been edited buy i think it should say unexpected!

Please Login or Register  to view this content.

works for me