Thread: selection range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default selection range

Have the following:
Range(Selection, Selection.End(xlDown) - 1).Select
Selection.FillDown
Selection.End(xlDown).Select

This is selecting everything to the next value in a list (I then filldown).
Need it to go to the value and then subtract 1 row from the range (so the
filldown does not overwrite the next value in the list).

Thanks.

--
Boris