1. P

    Run-time error '91' Help

    I'm not sure what I am doing wrong here. Sometimes when I open my worbook, I will get a Run-time error '91': Object variable or With block variable not set and sometimes I won't get it. That makes no sense but when I added the Option Explicit to the top of the code I get the error message every...
  2. G

    Application.Quit does not work when ActiveWindow.Visible is False

    Here's a real head scratcher...Within the BeforeClose event, I call one of two procedures depending on whether the workbook is the only workbook in that particular instance of Excel. The first works fine. The second ends up working exactly like the first despite the use of Application.Quit...

Some videos you may like

This Week's Hot Topics