I found this code on a link on this forum and it's exactly what I needed. The bad thing is it throws errors I can't figure out.
Any references to the variables MyRow and MyCol my sheet pops an error saying "Cells of Object _Global failed" I have this code sitting in it's own module, I'm calling it on VBAproject "this workbook" on open just for now. Eventually I will try and call it from one of my buttons. BTW that did nothing, but that will be another thread.
Please Login or Register  to view this content.