Formula Macro

  • Thread starter Thread starter silvertable81
  • Start date Start date
S

silvertable81

I want to make a macro with a VLOOKUP function, which looks on a char
of cell names, then cuts the cell named in the VLOOKUP, and pastes i
in a cell in the printable range.

Question; How do I make a macro do VLOOKUP. I'm relatively new and hav
only made macros using the recorder
 
Here is the basic code:

Range("C1") = "=VLOOKUP(A1,'WorkBookName.xls'!
$A$1:$B$100,2,FALSE)"
 
Back
Top