Try...

EN = ActiveCell.Value

Rick


"Wu" wrote in message
...
In a marco,
If I write --- EN = cells(1,1)
then, EN will equal to the data of cells(1,1)

The problem is :
The cursor will stop at different cell, not certain.
May be at cells(2,2), cells(3,10), cells(10,2)............., every time is
different.
So, I want to get the location of the cell, then set EN is equal to that
cell.

How to write in marco to get the location of cells.