| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2B or not 2B? - Go to cell Bx, depending on what row is selected
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2B or not 2B? - Go to cell Bx, depending on what row is selected
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2B or not 2B? - Go to cell Bx, depending on what row is selected
One way:
i = Cells(ActiveCell.Row, 2).Value In article .com, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I show a picture depending on what data is selected in a cell | Excel Discussion (Misc queries) | |||
| Cell data depending on column selected. | Excel Programming | |||
| Want add color to the cell depending on the value selected from th | Excel Programming | |||
| return a data list depending on a value selected within a drop dow | Excel Discussion (Misc queries) | |||
| Vb Application to locate a worksheet depending on the radio box selected | Excel Programming | |||
Linear Mode
