View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lsn lsn is offline
external usenet poster
 
Posts: 1
Default VLookup worksheet name

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?