临æ¶åçï¼æ²¡ç»è¿è°è¯ï¼åè½æ¯è®°å½sheet1çA1éçå
容ï¼å¨sheet2éé¢æ¾å°ç¸åºçåå
æ ¼ï¼è®°å½è¡æ°ååæ°ï¼ç¶åæ¾ç¤ºå¨sheet1çA2åA3ä¸
sub test()
dim keyword,keyrow,keycol as string
sheets("Sheet1").select
keyword=range("A1").formular1c1
sheets("Sheet2").select
Cells.Find(What:=keyword, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ '注ækeywordå¨è¿é
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, MatchByte:=False, SearchFormat:=False).Activate
keyrow=activecell.row
keycol=activecell.column
sheets("Sheet1").select
range("A2").formular1c1=keyrow
range("A3").formular1c1=keycol
end sub
温馨提示:答案为网友推荐,仅供参考