Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub SingleCell()
- Dim r1 As Range, r2 As Range
- Set r1 = Workbooks("Book1").Sheets("Sheet1").Range("A:A").Find(What:="Quote ID:").Offset(0, 1)
- Set r2 = Workbooks("Book2").Sheets("Sheet1").Range("B67")
- r1.Copy r2
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement