Autofill column with variable no. of rows

[bernard.x]

Hi, I'm trying to autofill a column with a macro. Rightfully I should be able to record it if the no. of rows are constant, howevever it is not andI'm getting a headache trying to find the code. Can someone please help me? I would appreciate it very much.


Example:
036411200W Vendor


036598000E Vendor



036899700J Vendor


Expect:
036411200W Vendor
036411200W
036411200W
036598000E Vendor

[blane245]

Welcome to the forum!

How's this? I assume you also wanted to fill down the second one as well. This will full down every string until it hits the last one.

Please Login or Register  to view this content.