Selection Autofill combined with End(x1Down)

[LewisLonsdale]

Hi everyone

When recording a macro this is the code I get

Please Login or Register  to view this content.

However I would like something like

Please Login or Register  to view this content.

Any suggestions?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[RedSummer]

You may need to give us some more information. Or a picture of the desired result. It says something about selection but will you always be filling in column B up to the last row? I was doing this code which does xlUp

Please Login or Register  to view this content.