Range Select

matt_boy · Nov 30th 2004

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

DrewBe · Nov 30th 2004

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

Richie(UK) · Nov 30th 2004

Re: Range Select

Hi Matt,

You just need to watch the placement of the quotes

Like this:[vba]Sub Test()
Dim I As Long

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

End Sub[/vba]HTH

jindon · Nov 30th 2004

Re: Range Select

Hi

Code

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

should work

hope this helps

jindon

matt_boy · Nov 30th 2004

Re: Range Select

Thanks guys, spent ages playing about with the quotes driving myself mental.

:thanx:

Participate now!