View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default VB Code Question Range(

To be consistent with your example, I think steve meant

cells(2,?) where, for column A, ? would be 1.

--
Regards,
Tom Ogilvy

"stevebriz" wrote:

cells(?,2).value
Sandy wrote:
is there a way to addreess a cell using the column number instead of the
column letter?

Instead of Range("A2").value .... Range(? & 2).value

Thank you