Guzzlr
Well-known Member
- Joined
- Apr 20, 2009
- Messages
- 982
- Office Version
- 2021
- Platform
- Windows
Hello All,
Having an issue...as always
The following code is finding Man-Hours, and placing it in cell G4. However, I also want to find the number associated with Man-Hours. This number is in the same column of A:A, and the next cell lower. For example, if Man-Hours is in A10, the number associated with it will be the number in A11.
Then, that number should be copy/paste as values in G5, next to the intersect of Man-Hours in G4.
Thanks for the help
Code:
Sub Find_ManHours()
Dim Fnd As Range
Set Fnd = Range("A:A").Find("MAN-HOURS:", , , xlWhole, , , False, , False)
If Not Fnd Is Nothing Then
Intersect(Range("4:5000"), Fnd.EntireColumn).Copy
Range("G4").PasteSpecial Paste:=xlPasteValues
End If
End Sub
Having an issue...as always
The following code is finding Man-Hours, and placing it in cell G4. However, I also want to find the number associated with Man-Hours. This number is in the same column of A:A, and the next cell lower. For example, if Man-Hours is in A10, the number associated with it will be the number in A11.
Then, that number should be copy/paste as values in G5, next to the intersect of Man-Hours in G4.
Thanks for the help
Last edited: