formula with code

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,110
Code:
Sheets("info").Range("B6").Value =????
How can we add up a vlookup formula into that code?
Thanks
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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
 

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,110
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
Code:
Sheets("Result").Range("B6:B25").Value = "=VLOOKUP(Result!RC[-1],'0600'!C[-1]:C[24],3)"
Hi,
Thats the one i've got but still its not giving me real result.
Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,058
Members
409,682
Latest member
HisHailo

This Week's Hot Topics

Top