Pinned Posts
Forum Widgets
Latest Discussions
Excel macro VBA issues
Hey guys. - I wrote a macro, which contain other macros using Call orders. If I running the macros separately everything ok, from the main macro one of them didn't running it's like it skipped from the list. Reason unknown. -On running I can see 4 application window get visible, and those didn't connect any kind of application. Also a Clipboard error message get visible, but I get a Clipboard cleaning macro, which several times cleaning the Clipboard, so it can't be. It's like a hack, or something which I don't recognize. - One a sheets called Total, I can't use the built in group function and can't collapse the selected section so the project I working on lost functionality. I didn't make any change on that side, but previously it was useable. Thanks for help in advance. Cheers. Zsolt
Too thick/fat gridlines when printing from excel
When I print a spreadsheet where I have selected/marked for gridlines, the gridlines become much thicker than they should be. They have the same thickness as the cells I have given borders. On the screen everything looks correct. The problem is only on the printout. I get the same problem no matter which printer I choose (has nothing to do with the printer driver). I have the latest operating system and drivers.
Average values for several parameters based on date and time ranges
I am searching for the Excel formula to calculate average values for several parameters based on date and time ranges. Yellow cells in the snapshot below are the ones I want to fill in with the formula. My goal is to be able to just change the date and time range and get the average. Columns F to J are minute-by-minute data. I have days of such data.
Running percentage
I want to create a formula that calculates the percentage of days that I completed a task throughout the month. For instance, I want my formula to calculate 90% if I complete a task 9 days out of the first 10 days of the month, and I want this formula to automatically calculate or update based on how many tasks I completed for each subsequent day of the month all the way to the end of the month. Thanks to whomever helps me with this.Excel 365 High CPu usage
Guys. Another issue not VBA-specific but it's important. I have an excel file and it's worked just fine. Without any huge changes, currently if I do something i.e change a sheet , jst try copy a cell my application is just freeze and in task manager the CPU show me a high % of usage. GPU-0 3 D- just will be visible and the power usage change from low to very high. I run the file without releasing VBA, but the result is the same. What it is? Excel 365. (Yesterday i did a reinstalling process.) You can see a short movie with explanation related to this issue. Attached to this message. Thanks your answers.Excel formula to determine missing numbers
In column S of Sheet 1 I have a list of case numbers. They all start with the year that the incident occurred &, followed by the incident number. On Sheet 2, I want to be able to quickly determine if any numbers in the sequence have been skipped. For instance, 2024-033, 2025-001, 2025-003, etc. There are never a set number of cases per year, so it wouldn't matter whether there should've been a 2024-034 after #33, but I would need to be able to readily see that 2025-002 was never input. If it matters, each year begins with '001' and not '000' and I'm working with Excel 2016.
Formule avec condition
bonjour J'ai un classeur de 13 feuilles, 1 avec les décomptes de mais différents repos, mes jours d'absences, mes nuits etc et 12 avec mon planning de chaque mois( noté de janvier à décembre), mon total de RU de départ est de 8(case B15 sur ma feuille décompte) et lorsque je faits plus de 5 nuits dans le mois( j'ai le décompte qui se fait sur chaque mois en case C12), je gagne 0,8 RU et je souhaiterai faire le rajout de 0,8 à chaque fois que la C12 de chaque mois est > 5 , en gros 8+0,8(si Janvier!C12>5)+0,8(si Février!C12>5)+0,8(si Mars!C12>5) .....+0,8(si Décembre!C12>5) Merci de votre aide
Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/maps /sites/Expesnes /sites/Expenses/2020 now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:- /sites/Marketing/Budget /sites/maps /sites/Expesnes is there any script i can run to do this cleanup? Thanks
