ExcelBanter - Qery open and clos sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Qery open and clos sheet (https://www.excelbanter.com/excel-programming/411965-qery-open-clos-sheet.html)

dan

Qery open and clos sheet

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

dennis

Qery open and clos sheet

VLOOKUP works whether the sheet you are looking up to is open or not.

"Dan" wrote:

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

All times are GMT +1. The time now is 08:31 PM.