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

[welchs101]

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.

[welchs101]

ok....i actually had an error in my first code but this error should not effect my question

corrected code:

myinputfile.Range("A1:A" & lst_row).FillDown

[welchs101]

ok....showing my ignorance..........its not .columns but rather .cells i think that i am referring to.

For example: How to select a range using the .cells method

myinputfile.Cells(lstrow, 1).Select

[welchs101]

romperstomper...........did not see your reply before i posted mine..........your really on top of things. sorry for the confusion.

[romperstomper]

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

[romperstomper]

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.

[royUK]

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

[welchs101]

hi guys,

What i want to do is filldown some data from cell 1 to say cell 10,000. I know the value i want to filldown its a constant.

Normally i do the filldown such as this:

myinputfile.Range("A2:A" & lst_row).FillDown

i was just curious if there was a way to do the same thing using a .cell


This is kind of a bad example but usually when i have to select ranges using the .range method i have to specify a col letter and i was wondering if there was a way to get around this ...........thoguht may be about the .cells.

[romperstomper]

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"

[welchs101]

thanks. I like the resize option for this answer.

Thanks.