Selecting range using .range. But can you do same selection using .columns

I know how to select a range of cells using code similar to the following:

Set myinputfile = Workbooks("Dav_16Jun2011.xlsx").Worksheets("Sheet1")
myinputfile.Range("A1:A" & alphacol(lst_row)).Select

i have a function called alphacol which converts lst_row number to character equivalent.

What i was wondering is .......is there a way to select range using the .columns

I know i can select individual cells using .columns ....such as

myinputfile.Columns(lst_row, 1).Select

But i dont know how to select a range using the column method.

None of that code will work. I suspect you are thinking of the Cells property rather than Columns?

The last code you posted will work, assuming the right sheet is selected first.
However, it is very rarely necessary to actually select cells in code.

You don't really need to select a Range

Set myinputfile = Workbooks("Dav_16Jun2011.xlsx")
myinputfile.Worksheets("Sheet1").Range("A1:A" & alphacol(lst_row)).Select

I don't know what this is

alphacol(lst_row

You can use resize, or use Cells with Range:

Cells(1, 1).Resize(1000, 1).Value = "blah"

Range(Cells(1, 1), cells(1000,1)).value = "blah"