Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row, Column
Hi All,
How cud I get the current row column1 column 3 etc.. i am using a find command and when the data is found i want to get column1 and column3 from that row. for eg: if the data is in X10 then i want to reference a10 and C10 .. something like range(row,1) or cell(row, 3) etc.. thanks Abdul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row, Column
Hi
try something like dim rng as range set rng=range("X10") 'replace with your find command msgbox cells(rng.row,1).value "Abdul" wrote: Hi All, How cud I get the current row column1 column 3 etc.. i am using a find command and when the data is found i want to get column1 and column3 from that row. for eg: if the data is in X10 then i want to reference a10 and C10 .. something like range(row,1) or cell(row, 3) etc.. thanks Abdul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row, Column
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 24 Then MyRow = Target.Row MsgBox "The Value of Col1 is " & Cells(MyRow, 1).Value MsgBox "The Value of Col3 is " & Cells(MyRow, 3).Value End If End Sub Does this help? "Abdul" wrote in message ... Hi All, How cud I get the current row column1 column 3 etc.. i am using a find command and when the data is found i want to get column1 and column3 from that row. for eg: if the data is in X10 then i want to reference a10 and C10 .. something like range(row,1) or cell(row, 3) etc.. thanks Abdul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) |