refer to another cell in the same row with the active cell
 

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.

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.

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.