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

You can do it like this...
Cells(ActiveCell.Row, 1)....for A
Cells(ActiveCell.Row, 2)....for B
Cells(ActiveCell.Row, 5).....for E

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