Autofill last row

[Guest]

autofill the last column. Let’s say G1 has the word complete how do I auto
fill till the last row of data,
Thanks,
DJ

 

[Frank Kabel]

Hi
double click on the lower right corner of your cell

 

[DavidC]

I have used the .filldown method.

typical code is:

sheets("name of sheet").range(start cell reference:finish
cell reference).filldown

BOL
DavidC

 

[Guest]

Thanks Guys I found my old post...Wheew!!

I have used the .filldown method.

typical code is:

sheets("name of sheet").range(start cell reference:finish
cell reference).filldown

BOL
DavidC