Range().select using variables



Hi,

I'm Am running vb script in Excel sheet, trying to use variable in
Range function and dont have any idea how.
Example :

let say my range to select is

Range("A2:C9").Select

i would ilke to use variable insted of number, lets say replace the 9
number with variable something like:

Range("A2:C'i'").Select <-- this one does work.

need your help.

Thanks a lot

Niko

.



Relevant Pages

  • Re: Range().select using variables
    ... > I'm Am running vb script in Excel sheet, ... > Range function and dont have any idea how. ... You should probably find an Excel VBA newsgroup to post this type of ...
    (microsoft.public.vb.general.discussion)
  • Re: Range().select using variables
    ... > I'm Am running vb script in Excel sheet, ... > Range function and dont have any idea how. ...
    (microsoft.public.vb.general.discussion)