vba - Return cell row and column of a cell after using find -


i searching vba command in combination find() (or similar) returns address of found cell in fixed column.

due programm, value searching exists once, apparently return value, not location.

 set cell = selection.find(what:=choice, lookin:=xlformulas,_  lookat:=xlwhole, searchorder:=xlbyrows, searchdirection:=xlnext,_  matchcase:=false, searchformat:=false) 

it easy question, appreciated!

write after code:

debug.print cell.row debug.print cell.column 

Comments