Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select rows
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select rows
Rows(startRow & ":" & endRow).Select
"Arne Hegefors" wrote: 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!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select rows
thanks for your help. look i am extremely bad at vba and especially cell
refenernces. i tried bopth your code and it did nor work. do i have to define startRow and endRow as something special (int, var, range). I have spent over two hours on this one single line.....i desperatly need help!!! "Newbie" skrev: Rows(startRow & ":" & endRow).Select "Arne Hegefors" wrote: 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!!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to select rows
Why not do it all in one line since you have the range objects anyways...
Range(relativCell.Offset(k, 0), relativCell.Offset(j, 0)).EntireRow.Select -- HTH... Jim Thomlinson "Arne Hegefors" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select between rows | Excel Discussion (Misc queries) | |||
How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
select rows | Excel Worksheet Functions | |||
select block of rows w/data between blank rows | Excel Programming | |||
Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) |