Help with Range Reference
 

I have the variable ColLetter as a string, and I want to refernce a range in
code

Say ColLetter is equal to B

Instead of doing Range(B5:B55) I want to do

Range(ColLetter&5:ColLetter&55)

Help with Range Reference
 

Range(ColLetter & "5:" & ColLetter & "55")

--
Kind regards,

Niek Otten

"Mike" wrote in message ...
|I have the variable ColLetter as a string, and I want to refernce a range in
| code
|
| Say ColLetter is equal to B
|
| Instead of doing Range(B5:B55) I want to do
|
| Range(ColLetter&5:ColLetter&55)
|
|

Help with Range Reference
 

Or

range(colLetter & "5").resize(51,1)
or
cells(5,colLetter).resize(51,1)

..resize(x,y) says to resize the range so that it ends up as x rows and y
columns.

Mike wrote:

I have the variable ColLetter as a string, and I want to refernce a range in
code

Say ColLetter is equal to B

Instead of doing Range(B5:B55) I want to do

Range(ColLetter&5:ColLetter&55)

--

Dave Peterson