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

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:

Range("AR4:AW" & Range("AR" & Rows.Count).End(xlUp).Row).FillDown

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:

Range("AR4:AW" & Range("A" & Rows.Count).End(xlUp).Row).FillDown

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