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