VLookup worksheet name

  • Thread starter Thread starter lsn
  • Start date Start date
L

lsn

I have a vLookup formula that is looking at a worksheet in a multiworksheet
workbook. I wanted to delete the worksheet and have it create the worksheet
via macro (this works just fine) but there seems to be a disconnect between
my vLookup. I cannot reference a worksheet that doesn't exist. Any
suggestions?
 
You can use the indirect function as it makes the connection when the formula
is evaluated instead of when the formula is typed...
 
In addition to Jim's answer, since you are creating the lookup range
worksheet via macro, you can also create the VLOOKUP formula after the
worksheet has been created.
 
Back
Top