Thread: Help with Range Reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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)


Reply With QuoteReply With Quote