[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

pilas31 Posted messages 1878 Status Contributor 648
 
Hello,

There is this syntax:

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

A+

--
Best regards,
4
adn
 
Thank you
0