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

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.