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