'This was the only way to copy multiple cells at once other ways it would just errorĬopyRange = Range(Cells(i + 3 - x1, x1 - 2), Cells(i + 3 - x1, x3 - 1)).Value Range(Cells(x1, x1), Cells(x1 + 1, x3 - 1)).Value = copyRange 'Declaring All of my Variables that are pulled from UserformĬopyRange = Range(Cells(x1, x1), Cells(x1 + 1, x3 - 1)).Value 'This brings up the data for my dropdown menu to pick a sheet to pull data from
Why does excel keep freezing mac code#
The Code Private Sub UserForm_Initialize() All size references and sheet names needs to be from a UserForm so I don't know the name of the sheets or size ahead of time this resulted in some weird code at the beginning of my loop.Īlso, if you see anyway to make my code more efficient that would be greatly appreciated! The data is a bunch of numbers that need to be put in one column, and that the 14 (normally 14) columns before it label each number with dates and other data. And it would be best if there was a solution in VBA so people don't have to worry about it and it works perfectly the first time. It would just be better so people that need to use the macro don't freak out when it freezes. Now I was wondering if there was a way to slow it down so that Excel does not go into "Not Responding" mode while it runs. It works great (I think) and does exactly what it needs to do and takes under 1 minute to run, going through ~70k cells and organizing them. So at work I am working on a macro/UserForm in Excel for someone.