Typical actions that cause memory error messages are: The first thing to determine is if the error is specific to one workbook (or others created from the same template). Sometimes we have files with formulas copied over to the entire sheet, and we can remove the extra part to make it work. Sometimes when we format data, we format the entire sheet, and the size of the file increases unnecessarily. Let us check if any of the Excel sheets have some extra formatting that is not required. There can be numerous reasons for such issues, and we will try to understand how we can resolve them when we are facing such issues:
' Again, this selects the first unhidden cell under the MHSS column for the new revision ' Y to future revisions' DND validations if Y was written for the current revision claims if Y was written for the newest revision, and ' This step writes Y to future revisions' comp. Offset(1, 0).SpecialCells(xlCellTypeVisible)(1).Row).Select
' This finds the newest revision in the database MHSS_Array(i) = MHSS_First.Offset(rowOffset:=(i - 1), columnOffset:=0).ValueĬomp_Claim_Array(i) = MHSS_First.Offset(rowOffset:=(i - 1), columnOffset:=-4).ValueĭND_Val_Array(i) = MHSS_First.Offset(rowOffset:=(i - 1), columnOffset:=-5).Value ' This step creates 3 arrays that store MHSS numbers, compliance form claim responses (as Y, N, or blank), and DND validation responses (as Y, N, or blank) ' This step selects the first unhidden cell under the MHSS columnĪctiveCell.Offset(rowOffset:=0, columnOffset:=1).Activate
' If the cell is empty, clear filters and filter for doc name with no 'Rev. ' Checks if all cells have been filtered (Selects first visible cell, checks if blank) # (Enter '0' if no revision number listed or if written as Rev.
EXCEL NOT ENOUGH MEMORY TO PERFORM ACTION FULL
'DocName = InputBox("Enter full document name you revised (without Rev. ' Get document number and revision number
EXCEL NOT ENOUGH MEMORY TO PERFORM ACTION CODE
Here's what my code looks like: Sub Yes() Basically, I'm just trying to shift down a filtered column and change the values in the column. I don't really know how else I can adjust my code so that it uses memory. So basically I get a popup whenever I run my code saying there isn't enough memory, but the error comes from two nested 30-element For loops.