Hello everyone. I'm new here, and pretty new to VBA in general (so I apologize for my clunky code). I have a fairly large workbook (@16mb) with several macros and the other day I went in to edit some of the macros to reflect streamlining and efficiency techniques I've been picking up through self-teaching and web research.....well, now for some reason each time I try to run one of the macros, Excel goes unresponsive ("Excel has stopped working.....") and I cannot for the life of me figure out what I've done to mess this up.
The macros in question are not super complex by any means......the one I am posting below I did f8 through and it seems to be crashing upon the declaration of LastRow as a variable............not sure why. Thoughts? Help is appreciated in advance and I apologize if this duplicates another thread, but I have not been able to find a specific problem like this through search yet....The long and short of this macro is I'm trying to copy formulas down to last populated row and then paste over them as values to save processing effort......
Bookmarks