asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Code:
Sheets("info").Range("B6").Value =????Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
formula with code
- Thread starter asyamonique
- Start date
texasalynn
Well-known Member
- Joined
- May 19, 2002
- Messages
- 8,458
enter your vlookup formula, then do a macro record
select the cell with the formula, press F2 and enter. stop the recorder
the macro will then have the formula, which you will need to modify. Post back with that code and questions
select the cell with the formula, press F2 and enter. stop the recorder
the macro will then have the formula, which you will need to modify. Post back with that code and questions
Upvote
0
asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Code:
Sheets("Result").Range("B6:B25").Value = "=VLOOKUP(Result!RC[-1],'0600'!C[-1]:C[24],3)"Thats the one i've got but still its not giving me real result.
Thanks
Upvote
0
Similar threads
- Solved
