I said nothing about a split window in your worksheet, which is entirely irrelevant. No-one is saying opening an embedded worksheet can't be done with VBA, but I have to wonder what the point is when you don't even know which embedded worksheet you want to open. Once one starts building sufficient logic into the code to handle that, it ends up being no faster than doing it without a macro.