one less than range filldown statement
 

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.
--
Boris

one less than range filldown statement
 

This'll do it:

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


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=560728

one less than range filldown statement
 

worked like a charm. Thx much.
--
Boris


"colofnature" wrote:


This'll do it:

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


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=560728