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.