vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
IN VBA , I want to use vlookup from the other sheet within the same workbook but I do not want to use worksheet name (DOVE) in formula
Currently, I am using the below formula and it is working fine
Currently, I am using the below formula and it is working fine
VBA Code:
Range("C2").Formula = "=VLOOKUP(B2,DOVE!$C$14:$C$1048576,1,0)"