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)
|
|