Darron,

Try it this way:

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



"Darron Ross" wrote:

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