Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 _____________ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Multiple Columns in a Named Selection | Excel Worksheet Functions | |||
Selecting specific row/column from a named range | Excel Worksheet Functions | |||
Problem selecting a named range | Excel Programming | |||
Selecting/Printing a Named Range via VBA | Excel Programming | |||
Selecting Filtered Items from Named range | Excel Programming |