Private Sub CommandButton1_Click() A = Application.InputBox("輸入uF數值") X = MsgBox("是否繼續執行?", 1 + 64) If X = 1 Then Cells(63, 5) = A Cells(64, 5) = "uF" Cells(54, 5) = [F62] On Error Resume Next With Sheets("sheet1") Sheets("sheet1").Cells(Application.Match([G59], [sheet1!a:a], 0), 3) = [e59].Value End With End If End Sub 有辦法改為 Match([G59], [sheet1!a52:k52]這樣,然後對應往下2格存入嗎(原來是往右)? 謝謝
This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.
留言列表