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

Hi Darron

It is Cells(row,column)

Not column,row

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Darron Ross" wrote in message ...
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

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