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

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

One way:

i = Cells(ActiveCell.Row, 2).Value


In article <(E-Mail Removed)>,
bony_tony <(E-Mail Removed)> 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