autofill in macro range is constant- how can I code to be a variable range?

I am trying to write a macro which will autofill specific columns. The macro will set the range from the start of my autofill to the end of my autofill as a constant range.
The problem I need to get around is the end of my range can always change each time I run the macro. For instance, the first time I run the macro I may only need to autofill from row 4 to row 15. The next time, I may only need to autofill from row 4 to 23 (because of user updates). How can I make the end of my range not be a constant address but variable?


Range("AR4:AW4").Select
Selection.AutoFill Destination:=Range("AR4:AW15") <---- 15 changes from day to day

It's easy enough to do, but how do you determine what the last row is? Is there a flag, or some other way to tell? If so, it can likely be incorporated into the macro.

Ok... so you have a column of data, and you want the filldown to the end of that column?

Essentially you just said that you use Shift+End+DownArrow. I'm assuming that's because you're at the top of a column of data, and you want to select all the way down to the end of that column. Yes? If so, based on your example is that column AR?

You might try something like:

Please Login or Register  to view this content.

Almost. But still can't get it. Here is an example

......A .....B.......C..............................AR.........AS..........AT.......AU.......AV......AW
.4...xx...xxx.....xxx...........................xxxx......xxxx.......xxxx.....xxxx....xxxx....xxxx
.5...xx...xxx.....xxx................................................................................................
.6...xx...xxx.....xxx................................................................................................
.7...xx...xxx.....xxx................................................................................................
.8 ..xx...xxx.....xxx...............................................................................................
.9...xx...xxx.....xxx................................................................................................
10..xx...xxx.....xxx...............................................................................................


The spreadsheet would always have values in the first couple of columns. In this case, my last row row is row 10. I would then need to autofill columns AR:AW through row 10.
I tried you last suggestion, but it only filled one extra row.

You missed part of my post then.

If so, based on your example is that column AR?

Based on your latest post, that is column A (or B or C). So change the code to:

Please Login or Register  to view this content.

This will find the last used row in column A, and use that to set the filldown limit.