Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

syntax - selecting a range of rows 1

Status
Not open for further replies.

LisaBee

Technical User
Jun 23, 2006
18
US
I'm almost embarrassed to ask, but obviously not too proud . . .
What's the correct syntax for identifying the range of rows when I want to use a variable to identify the starting row?

Rows("StartRow:1000").Select

Thanks very much :)

Lisa
 
Rows(StartRow & ":1000").Select

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
That was perfect -- Thanks again very much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top