selection command, problem with column index
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
|