I've set up a vlookuop. I want to retrieve a blank value. Lookupup code is the number 1 and the value for one is blank. At one point it worked fine and now it won't.

I've set up a main menu in excelfor excel worksheets in a workbook. When I bookmark a worksheet I would like a macro to autostart to print the sheet. Possible?

I'm using excel 2000.

thanks for the help.

You might have used relative reference in VLOOKUP for table of array therefore it might be generating wrong reuslts.

I could help you more if you exactly write your function and give an example of worksheet here.