try this :
i Cells(Selection.Row, 2)

Regards,

Halim


"bony_tony" wrote:

Hi,
I'm no vba programmer, I can record macros, do loops etc, but I'm not
sure how/why each statement is structured the way it is.
What I want to do is store the value from a specific cell. The cell
is located in column B, and in the row of the current selection. ie,
if cell J23 is selected, I want to store the value of J2 as i. If A1
is the current selected cell, then it should be A2 which is stored as
i...

From trying to figure it out myself, i've got
i = Cells(Row.Selection, 2)
Can someone tell me where I'm going wrong?

Cheers