No need to select at all:-
Sub Cols()
With Columns("E:R")
.ColumnWidth = 10.25
.EntireColumn.Hidden = False
End With
With Columns("S:T")
.EntireColumn.Hidden = True
End With
With Columns("U:U")
.ColumnWidth = 13
End With
End Sub
or
Sub Cols()
With Columns("E:R")
.ColumnWidth = 10.25
.EntireColumn.Hidden = False
End With
Columns("S:T").EntireColumn.Hidden = True
Columns("U:U").ColumnWidth = 13
End Sub
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"mark kubicki" wrote in message
...
once again, i'm having a problem selecting an entire column(s):
the following code consistently selects more columns than i want:
Columns("E:R").Select
With Selection
.columnwidth = 10.25
.EntireColumn.Hidden = False
End With
Columns("S:T").Select
With Selection
.EntireColumn.Hidden = True
End With
Columns("U:U").Select
With Selection
.columnwidth = 13
End With
as always, thanks in advance
mark
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.594 / Virus Database: 377 - Release Date: 24/02/2004