Assign vaiable to a cell - gold

  • Thread starter gold gold via OfficeKB.com
  • Start date
G

gold gold via OfficeKB.com

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
 
D

Dave Peterson

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.
 
Top