Run-time error 7 out of memory vba

Hi,

I was using a Macro that populates blank cells:

Please Login or Register  to view this content.

Which worked fine, however I found myself using this more and more and so decided to set myself up a Userform that opens from a Custom Menu Button and changed the code to select the column letter based off of a combobox selection, which reads like so:

Please Login or Register  to view this content.

However everytime I run this macro now I get the:

Run-time error 7 out of memory

message which I have never seen before. Does anybody have ay ideas?

Thanks in advance Macro1

Thanks Romperstomer,

That has worked a treat