View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darron Ross[_3_] Darron Ross[_3_] is offline
external usenet poster
 
Posts: 2
Default 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