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