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:


    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 = 4
    Range("N & I:U & I").Select

    Cannot be done yet

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


    Is there anyone that can explain this to me?

    Thanks for the help in advance

    Matt B

  • 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

    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

Participate now!

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