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.
Bookmarks