| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to another cell in the same row with the active cell
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to another cell in the same row with the active cell
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 "shiro" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to another cell in the same row with the active cell
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 shiro wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell in new sheet should always refer to defined cell in another s | Excel Discussion (Misc queries) | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Refer a specific cell in a named cell range | Excel Programming | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| How to refer the results of one cell to another cell? | Excel Discussion (Misc queries) | |||
![shiro[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
