Both of you are correct and I was wrong. I was in a hurry I guess I
commented wrong when testing.
..columns 'gets a1:e1
..entirecolumn 'of course, does the whole column
so solly

--
Don Guillett
SalesAid Software

"Norman Jones" wrote in message
...
Hi Don,

Just tested. Both do the SAME and I like to keep em short

From the intermediate window:

Range(Cells(1, 1), Cells(1, 5)).Columns.Select
? Selection.address
$A$1:$E$1

Range(Cells(1, 1), Cells(1, 5)).entireColumn.Select
? Selection.Address
$A:$E

What was your test?

---
Regards,
Norman



"Don Guillett" wrote in message
...
Just tested. Both do the SAME and I like to keep em short.

--
Don Guillett
SalesAid Software

"Norman Jones" wrote in message
...
Hi Don,

Range(Cells(1, 1), Cells(1, 5)).Columns.Select


I think you intended:

Range(Cells(1, 1), Cells(1, 5)).entireColumn.Select

---
Regards,
Norman



"Don Guillett" wrote in message
...
one way using numbers.
Sub selectcolumns()
'Columns("a:e").Select
Range(Cells(1, 1), Cells(1, 5)).Columns.Select
End Sub

--
Don Guillett
SalesAid Software

"Marvin" wrote in message
...
I can use a statement like:

rows("3:5").select

I can use a statement like:

columns(3).select

but

columns("3:5").select

fails.

My objective is to select a number of columns based on a
cell value, starting with the current column.
Is it necessary for me to calculate the column "letters"
or is there a simpler way?

Thanks.