I am scratching my head over this: I can select rows 1 to 20 by
rows("1:20").select. How come I can't select columns 1 to 20 by
columns("1:20").select?

Because the address of row 1 is 1 while the address of column 1 is "A" so:
Columns("A:T").Select
or
Range(Cells(1, 1), Cells(1, 20)).EntireColumn.Select

Hope this helps
Rowan

Shatin wrote:
I am scratching my head over this: I can select rows 1 to 20 by
rows("1:20").select. How come I can't select columns 1 to 20 by
columns("1:20").select?

columns use alphabets please

"Shatin" wrote:

I am scratching my head over this: I can select rows 1 to 20 by
rows("1:20").select. How come I can't select columns 1 to 20 by
columns("1:20").select?

Shatin,
Because Columns are "lettered" not numbered.
Try Columns("A:E")

NickHK

"Shatin" wrote in message
...
I am scratching my head over this: I can select rows 1 to 20 by
rows("1:20").select. How come I can't select columns 1 to 20 by
columns("1:20").select?

Probably for consistency.

Range("1:20") refers to rows
Range("A:T") refers to columns.

While Columns("1:20") would not be ambiguous, for consistency I assume they
chose to require letters.

--
Regards,
Tom Ogilvy



"Shatin" wrote in message
...
I am scratching my head over this: I can select rows 1 to 20 by
rows("1:20").select. How come I can't select columns 1 to 20 by
columns("1:20").select?