Thread: refer to another cell in the same row with the active cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default refer to another cell in the same row with the active cell
Hi

MsgBox Cells(ActiveCell.Row, 1)

This would give column a of the activerow so change the 1 to a 2 for B and 5
for E.

Mike

"shiro" wrote:

Hi All,
Have a good day.

How to refer to the cell in column A,column B and column E
which in the same row with the active cell?

Hopw somebody like to help.



Reply With QuoteReply With Quote