one less than range filldown statement

[Guest]

Have the following code:

Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:A112").Select
Selection.FillDown
Selection.End(xlDown).Select

Trying to start from a cell, ctrl-shft-down to next cell, and then go one
cell LESS than that range, then filling down. How do I get that "one less"
part after it fills down (or as part of the selection)?

Thx.

 

[colofnature]

This'll do it:

range(activecell, activecell.end(xldown).offset(-1,0)).filldown


Col

 

[Guest]

worked like a charm. Thx much.