![]() ![]() Main = Array("RJMC", "RJPME", "RJEF", "RJSMC", "Heritage", "RJE+") 'onglets Wb = Array("RJMC6", "RJPME8", "RJ Europe Flex 1", "RJSMC", "Heritage", "RJ Green impact") 'wb Private Sub CommandButton1_Click()ĭim FilePath$, Row$, Column$, Address$, SheetName$, i As Integer, numRows As Long, j As Long, wb, rowz As Variant, dummz As Variant, myVars As New Collection, curr As Variant, test As Variant It's quite frustrating and I can't seem to identify the issue? Does anyone know the answer to this? I've inserted an example of my code below (btw I'm open to tips to make my coding more efficient, am learning.). ![]() Oftentimes I get an error message ("Out of memory") then when I click on either "ok" or if I close the message, it crashes and all excel files close without saving them. I created a macro on Excel VBA to automatize some standard tasks. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |