selection command, problem with column index

[Guest]

I'm using the selection command and I'm havinig trouble with the columnindex.

With Selection
Range(.Cells, Cells(.Row, "iv")).Select
End With

The above works fine but when I use column instead if row as below:

With Selection
Range(.Cells, Cells(.Column, "6000")).Select
End With

I get an Run-time error 1004 application-defined or object-definde error

I believe it's because i'm not using the correct column indexing.


thanks for any help darron

 

[Ron de Bruin]

Hi Darron

It is Cells(row,column)

Not column,row

 

[Guest]

Darron,

Try it this way:

With Selection
Range(.Cells, Cells(6000, .Column)).Select
End With