Row, Column

[Abdul]

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

 

[Guest]

Hi
try something like
dim rng as range
set rng=range("X10")
'replace with your find command

msgbox cells(rng.row,1).value

 

[Jim May]

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?