column selection in vba

[aviadht]

<TABLE class=tborder id=post2395995 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_2395995 style="BORDER-RIGHT: #ffffff 1px solid">I want to select columns with parameters

parameter 1: col1
parameter 2:col2

and the next one not working: columns(col1,col2).select

why ?

Aviad
<!-- / message --></TD></TR><TR><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 1px solid">

</TD><TD class=alt1 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-BOTTOM: #ffffff 1px solid" align=right><!-- controls -->

</TD></TR></TBODY></TABLE>

 

[Scott Huish]

Its rarely necessary to select.

But here you go:

Sub test()
Dim col1 As Long, col2 As Long
col1 = 5: col2 = 17
Range(Columns(col1), Columns(col2)).Select
End Sub

 

[aviadht]

ok, thank you..it works..but now i have another question (-:

asume that i'm on activecell and i want the parameter (integer) "colnum" to get te activecell column number. for example column b number is 2.

how can i do that ?

Regards,
Aviad

 

[Scott Huish]

Sub test()
Dim col1 As Long, col2 As Long
col1 = ActiveCell.Column: col2 = 17
Range(Columns(col1), Columns(col2)).Select
End Sub