will this work?

Sub selectrows()
Rows("1:" & Range("b10")).Select
End Sub

--
Don Guillett
SalesAid Software

"Lang" wrote in message
...
Hi,

I'm having a hard time figuring out how to set a variable in a macro equal
to the value in a cell. I then want to be able to use that value with the
select method to select a number of rows equal to the value of my
variable.

The big problem for me is going from the spreadsheet to the macro with a
value.
Any help appreciated.

Thanks,

Lang