Wow, thanks macropod, I'll start playing around with those and see how I might be able to integrate them, unfortunatly for the time being I forgot the first rule in trying to idiot proof anything: someone can always build a better idiot... *smacks forehead*
thanks Geoff, wound up adding in a confirm box to separate the macros, last day of my work week and I'm running out of time. Also, removing the =true seems to have fixed the screenupdate problem.
I realize that Skip, but the problem that I'm trying to circumvent is when others enter info into our spreadsheet, make small mistakes, and rather than correct them the right way, they use the easy way, which alters the formulas, ect. ect. I'm trying to idiot proof the spreadsheet to make...
ok, so revised my code a bit but still have some bugs, sorry PHV, but yours kept giving me range errors, Geoff (by the way, are you per chance the same Geoff from RTP LLC? just curious) I'm still having problems with the screenupdate turning itself back on when I run from the MasterCallMacro...
I am working on combining a macro that converts integers that are simulated to be in a time format, into an actual format( this one works, we have been using it for over 4 years with no trouble other than it is slow). and a new macro that checks for data in the columns A,Q,R,S,T,U,V and W...
I am working on combining a macro that converts integers that are simulated to be in a time format, into an actual format( this one works, we have been using it for over 4 years with no trouble other than it is slow). and a new macro that checks for data in the columns A,Q,R,S,T,U,V and W...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.