Range Reference Problem
On Tue, 18 Oct 2011 10:49:37 -0700 (PDT), sylink wrote:
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.
Not tested:
Try: Range("B2","D" & Z)
or
Range("B2:D" & Z)
|