arehman1289
New Member
- Joined
- Dec 10, 2020
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Hello
Im trying to insert a formula in a cell, with a mix of strings and integer values but am unsuccessfull.
nr = 41
For k = 1 To 21
If k = 3 Then
Cells((nr + k), "D").Value = "VLOOKUP('User Input'!$C(nr+k),'Work process list'!$A$2:$B$11,2,FALSE)"
End If
Next k
All it does is paste "VLOOKUP('User Input'!$C(nr+k),'Work process list'!$A$2:$B$11,2,FALSE)" as a string.
In this part of the formula C(nr+k)
I would like it to iterate through the rows of the C Column of the worksheet User Input.
Please help
Im trying to insert a formula in a cell, with a mix of strings and integer values but am unsuccessfull.
nr = 41
For k = 1 To 21
If k = 3 Then
Cells((nr + k), "D").Value = "VLOOKUP('User Input'!$C(nr+k),'Work process list'!$A$2:$B$11,2,FALSE)"
End If
Next k
All it does is paste "VLOOKUP('User Input'!$C(nr+k),'Work process list'!$A$2:$B$11,2,FALSE)" as a string.
In this part of the formula C(nr+k)
I would like it to iterate through the rows of the C Column of the worksheet User Input.
Please help