Assign vaiable to a cell - gold

HI,,, im just wondering how will I assign a variable to a cell that will b
used in a Range....

Here's the situation:

Range("a:b").Select

where a and b are variables assigned as integer

Please please please ....

i need this urgent....

thank you

dim a as long
dim b as long
a = 3
b = 18
range(a & ":" & b).select

This will select rows 3:18.

range(rows(a),rows(b)).select

will do the same.

If you're working with rows, you'll want to use Longs instead of integers.

"gold gold via OfficeKB.com" wrote:
>
> HI,,, im just wondering how will I assign a variable to a cell that will b
> used in a Range....
>
> Here's the situation:
>
> Range("a:b").Select
>
> where a and b are variables assigned as integer
>
> Please please please ....
>
> i need this urgent....
>
> thank you

--

Dave Peterson