ArrayList runtime error 1004

  • I have the following Macro that is activated when clicking a button.

    However, when I open a worksheet and click a Button assigned this Macro I get a runtime 1004 error on the rowList.Add sShape.TopLeftCell.Row + j line. This error disappears when I click the button the second time.

    Any suggestions on how to resolve this?

  • I can not duplicate your problem. I tried ActiveX and Forms command buttons and shape controls.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!