Dynamic Autofilling

So I have to write a macro which automatically finds and extends a range which I have set to this

Please Login or Register  to view this content.

into the next empty column, but for some reason when I try to do that with this line;

Please Login or Register  to view this content.

i get a 1004 error. Any ideas? lcol is what I have set as the next empty column.

Hello omgeokid,

You need to define a source range, a few cells that represent the fill sequence, and then include that in the destination. In the example below, the first 2 cells of the range are used to define the fill type.

Please Login or Register  to view this content.