VLookup worksheet name

[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?

 

[Jim Thomlinson]

You can use the indirect function as it makes the connection when the formula
is evaluated instead of when the formula is typed...

 

[Duke Carey]

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.