View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Select cells in a column

Hi Evan,

Is there a way to refer to the last used cell in column K without using the
Cells method? Meaning a literal way such as:


Simply replace the column number with the correspondinf column letter in
your expressions.

For example, the expressions cells(1,4) and cells(1,"D") are completely
equivalent.


---
Regards,
Norman.