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

S

shiro

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.
 
M

Mike H

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
 
A

aamerrasheed

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
 
Top