View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Trying to select rows

Range(Rows(startRow),Rows(endRow)).Select

HTH
--
AP

"Arne Hegefors" a écrit dans le
message de news: ...
Ok i have a problem that I dont understand. I guess its easy if you know
it
but I dont and its really bugging me..I try to select several rows by
writing:

startRow = relativCell.Offset(k, 0).Row
endRow = relativCell.Offset(j, 0).Row

Rows(startRow, endRow).Select

this is obviously wrong but how do you write it? The two first lines are
correct but the line RoWs(.....).Select is faulty inside the parenthisis.
Please help me out if you know this!!!