hello all,
i have recorded multiple macros that make liberal use of autofill within. i reuse the macro weekly. when i edit the macro, the auotfill command within might look something like:
Range("B2").Select
Selection.AutoFill Destination:=Range("B2:B4828")
my problem is, the size of the file is different each week, so i have always edited these recorded lines to over fill:
Range("B2").Select
Selection.AutoFill Destination:=Range("B2:B6000")
and this will work until the file grows larger than 6000 lines.
i want to know how i can fix this to adapt to any size file (rows) that might occur.
thank you for any help you can offer!
i have recorded multiple macros that make liberal use of autofill within. i reuse the macro weekly. when i edit the macro, the auotfill command within might look something like:
Range("B2").Select
Selection.AutoFill Destination:=Range("B2:B4828")
my problem is, the size of the file is different each week, so i have always edited these recorded lines to over fill:
Range("B2").Select
Selection.AutoFill Destination:=Range("B2:B6000")
and this will work until the file grows larger than 6000 lines.
i want to know how i can fix this to adapt to any size file (rows) that might occur.
thank you for any help you can offer!