Using Autofill in an Excel Macro

[Yevette]

Hello All,

I am using Excel 2000 and I was wondering if someone could tell me how to write a macro to use the Autofill function that will allow for change in the total number of rows. For instance in the example below:

Selection.AutoFill Destination:=Range("K2:K245")

I don't want the range to just be k2:k245 because K245 will change constantly depending on the number of employees.

I tried using the search function for this topic but came up empty handed. I hope this is clear. Thanks a lot for your help.

 

[LTunnicliffe]

Try something like this:

Selection.AutoFill Destination:=Range("K2:K" & Range("K65536").end(xlup).Row)

Hope this helps!

 

[Yevette]

Hi,

It worked perfectly, I just needed to change the K65536 to J65536. Thanks so much for your help! Have a great day!