Range Select

  • Hopefully this is going to be easy for you all but I've been trying to figure this out for a while now and I can't find anything here already.


    I want to select a range which is normally fairly simple:


    Code
    Range("N6:u6").Select


    However for some reason I cant select this range when using an oustide reference (i can select a single cell but not a selection.)


    i.e


    Code
    I = 4
    Range("N & I:U & I").Select


    Cannot be done yet


    Code
    I = 4
    Range ("N" & I).Select


    can


    Is there anyone that can explain this to me?


    Thanks for the help in advance

  • Re: Range Select


    I do not believe vba can handle the : symbol for this usage (i seem to remember having issues with it at one point).
    You could try the code


    Code
    I="your number"
    Range(Cells(I,14), Cells(I,21)).Select


    if your range is always between Columns N (14) and U (21)


    Hope this helps
    DrewBe

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!