View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Reference to Columns

Range(Columns(2), Columns(10)).Select

Mike F
"Angeles" wrote in message
...
Hi , I am using the next line :

ActiveWorkbook.Worksheets("A").Columns((ConvertToL etter(inicol)) & ":" &
msConvertToLetter(endcol)).Select

Does exist some way for using only the Column Number ? I would prefer
donīt
use the function ConvertToLetter.

Thank you in advance.