Thread: use a variable to set a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norie Norie is offline
external usenet poster
  
Posts: 82
Default use a variable to set a range
There's no need to convert to the letter.

If you have the column number you could just use it.

ColNum = 3 ' column 3 is column C

Columns(ColNum).Interior.Color = vbRed


Reply With QuoteReply With Quote