[VBA-excel] select columns

mortelrdv -  
 adn -
Hello,

in VBA, I can select multiple columns by doing this:
columns("A:C").select

Since my variables are numeric (I want to avoid converting to letters), I was wondering if there is a way like:
columns("1:3").select

Thank you
Configuration: Windows XP Firefox 3.5.3

1 answer

  1. pilas31 Posted messages 1878 Status Contributor 648
     
    Hello,

    There is this syntax:

    Range(Columns(1), Columns(3)).Select

    A+

    --
    Best regards,
    4
    1. adn
       
      Thank you
      0