Excel総合相談所 84

100×100マスを探す場合

sub 検索

a=inputbox("文字を入力すれ")

for b = 1 to 100
for c = 1 to 100
if cells(b,c)=a then
cells(b,c).activate
exit sub
next
next

end sub