View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hdf hdf is offline
external usenet poster
 
Posts: 30
Default Selecting multiple rows in a named range

I have a single column, 40 row range called NAMES.

I know I can select the first row in the range and place the value "0"
in it using the code below. But how do I select just rows 2-40 and
not the first row?

___________

Sub SelectRows()

Range("NAMES") = Clear
With Range("NAMES")
.Rows(1).Select
.Value = 0

End With

End Sub

_____________