Range Reference Problem

[sylink]

I need to convert this range reference to a variable one using "Z" for
only "D4005". "B2" is static and therefore need not be changed.


Dim Z As Integer

Range( "B24005")

I attempted something like this without success:

Range("B2 & Z & ")


Thank you for your anticipated response.

 

[Claus Busch]

Hi,

Am Tue, 18 Oct 2011 10:49:37 -0700 (PDT) schrieb sylink:

Range("B2 & Z & ")

try:
Range("B2" & Z)

Regards
Claus Busch

 

[Ron Rosenfeld]

I need to convert this range reference to a variable one using "Z" for
only "D4005". "B2" is static and therefore need not be changed.


Dim Z As Integer

Range( "B24005")

I attempted something like this without success:

Range("B2 & Z & ")


Thank you for your anticipated response.

Not tested:

Try: Range("B2","D" & Z)

or

Range("B2" & Z)

 

[Andrew]

Not tested:

Try:   Range("B2","D" & Z)

or

    Range("B2" & Z)

Try this:
Range(cells(2,2),cells(4,Z))