vb step run macro

  1. M

    Macro hanging up on its own, but works with "Step Into..." - Excel07

    I'm using the macro below to fill in some cells, then create a Pivot Table in a new worksheet. The macro works fine if I hit F8 (Step Into...) repeatedly in VB, but when I try simply press the "Run" button, it freezes up at Range("H2:H60000").Select. Any thoughts on why this is happening?

Some videos you may like

This Week's Hot Topics