Select rows using a variable
 

Hey guys I am trying to store a row number into a variable and then use
those variables to select a range. For example:

Rows("x:y").Select

It doesn't allow me to do this, is there another way?


--
jnasr00
------------------------------------------------------------------------
jnasr00's Profile: http://www.excelforum.com/member.php...o&userid=28515
View this thread: http://www.excelforum.com/showthread...hreadid=482118

Select rows using a variable
 

try this example

Sub test()
x = 4
y = 7
Range(Rows(x), Rows(y)).Delete
End Sub

--


Gary


"jnasr00" wrote in
message ...

Hey guys I am trying to store a row number into a variable and then use
those variables to select a range. For example:

Rows("x:y").Select

It doesn't allow me to do this, is there another way?


--
jnasr00
------------------------------------------------------------------------
jnasr00's Profile:
http://www.excelforum.com/member.php...o&userid=28515
View this thread: http://www.excelforum.com/showthread...hreadid=482118