dim sr as long,er as long
sr=1
er=500
myrange=ws.rows(sr &":"& er)
You are missing a right parenthesis character.
ws.range(ws.cells(1,1),ws.cells(500, 1).EntireR ow.Select
fails with "Select method of range failed", so I can't verify if I really have the range of rows I want in r1.
ws.range(ws.cells(1,1),ws.cells(500,1)).EntireRow.Select
Open in new window
This will select row number-1 to row -500 in your my range..Now in order to select as well you can do this...
Open in new window
or
Open in new window
Saurabh...