Autofill last row

D

Duncan_J

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
 
D

DavidC

I have used the .filldown method.

typical code is:

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

BOL
DavidC
 
D

Duncan_J

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

DavidC said:
I have used the .filldown method.

typical code is:

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

BOL
DavidC
 
Top