J
JOn Kunces
I have a large file but it varies in size each month. When i recorded a
macro the file seems to copy down the column in a fixed method as shown below-
Selection.AutoFill Destination:=Range("H2:H15952")
Range("H2:H15952").Select
I was wondering what i can insert in these areas so that it will AutoFill
automatically to the bottom row of column F no matter how many cells are
present.
Please help me out. Thanks
macro the file seems to copy down the column in a fixed method as shown below-
Selection.AutoFill Destination:=Range("H2:H15952")
Range("H2:H15952").Select
I was wondering what i can insert in these areas so that it will AutoFill
automatically to the bottom row of column F no matter how many cells are
present.
Please help me out. Thanks