LoginSignup
0
0

More than 1 year has passed since last update.

VBA要素抽出ツール

Last updated at Posted at 2022-11-14

Sub 抽出()
Dim objName As String
Dim objRange As Range
Dim myObj As Range
Dim i As Long
Set ws1 = Worksheets("抽出先")
Set ws2 = Worksheets("抽出元")
Set objRange = ws2.Range("A2:K61")
objName = ws1.Cells(2, 1).Value
Set myObj = objRange.Find(objName, lookat:=xlPart)
ws1.Cells(2, 2).Value = ws2.Cells(myObj.Row, myObj.Column + 2).Value

End Sub

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0