[PeterAV]

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.

[soullhacker]

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.