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
Post a Comment