View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default 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