Getting error Procedure too large in VBA Macros (Excel)
You will get that error if your procedure is more than 64kb. These are some of the things that you can to compact your code 1) Get rid of repetitive code. See this example Sub Sample() Range(“A1”) = “Blah Blah” Range(“A2”) = “Blah Blah” Range(“A3”) = “Blah Blah” Range(“A4”) = “Blah Blah” Range(“A5”) = “Blah … Read more