The macro I am currently writing in excel VBA has the problem of causing the entire excel workbook to crash on some occasions while having no crash effect on other occasions. In between running the macro and having it crash/not crash I will make tiny changes to the code which could "cause" the macro to crash, but when I restart excel and make the changes again, the macro runs smoothly without crashing. Would anybody be able to help me out and see if there is a loop or something that I am not closing or a coding error I am doing? I am not used to coding in VBA so I'm not completely sure of all the nuances.
Also at the end of my code where I have the single sided page printing code,(The part with Dim i as long, for i=1..........) "commented", out, is there a way to fix this so that it will only print when I want it to print instead of whenever I run the code WITHOUT, having to comment out that entire portion of code whenever I just want to run the code?
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks