Variables in Excel

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

will this work?

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

--
Don Guillett
SalesAid Software
[email protected]
"Lang" <[email protected]> wrote in message
news:[email protected]...
> 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

thanks for the reply Don! I didn't get a chance to check this today, but
will try soon.

Lang

"Don Guillett" wrote:

> will this work?
>
> Sub selectrows()
> Rows("1:" & Range("b10")).Select
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Lang" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

to use the value of a range (cell) in a macro, use the syntax:

Please Login or Register  to view this content.

where "a1" is value of interest.
then, to select a row use

Please Login or Register  to view this content.

to select that row number, or

Please Login or Register  to view this content.

to select that number of rows