Range Reference Problem

S

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( "B2:D4005")

I attempted something like this without success:

Range("B2:D & Z & ")


Thank you for your anticipated response.
 
R

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( "B2:D4005")

I attempted something like this without success:

Range("B2:D & Z & ")


Thank you for your anticipated response.
Click to expand...

Not tested:

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

or

Range("B2:D" & Z)
 
Top