Qery open and clos sheet

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I need to query (vlookup) another sheet that is sometimes open and sometimes
close - is there a way to do it via code?
Many thanks
Dan
 
VLOOKUP works whether the sheet you are looking up to is open or not.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy work sheet to another work book, pros and cons 1
ADOBE Connection to open Excel workbook 3
Unhide sheet 2
Sheet that never closes 4
copy external data 2
Corrupted sheet - What the cause? 2
Excel Run-time error '1004' General ODBC Error 1
Code works on sheet but not from code-to-sheet 2

Back
Top