| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup worksheet name
You can use the indirect function as it makes the connection when the formula
is evaluated instead of when the formula is typed... -- HTH... Jim Thomlinson "lsn" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup worksheet name
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. "lsn" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple worksheet vlookup | Excel Discussion (Misc queries) | |||
| Vlookup In Another Worksheet | Excel Discussion (Misc queries) | |||
| How to Use Vlookup to merge 2 different worksheet | Excel Discussion (Misc queries) | |||
| Vlookup in a second worksheet | Excel Worksheet Functions | |||
| vlookup worksheet(s) | Excel Discussion (Misc queries) | |||
Linear Mode
