The proble is that when you use a template file this gets 'imbedded' in the reference to a button or filed, you will have to edit the formula's used a...
I assume that the file you attached is just a sample since it contains no macros or are you using another workbook to run the code you've posted?
If any of the cells in the selected range contain an error like #DIV0, #NA, #VALUE your result will not calculate correctly unless you include an erro...
Hi Sam, dates are still a p in the A when it comes to dates. My solution is to always try and convert any data or text that is a date value to a seria...
Hi Sherry, I haven't really gone through your code thoroughly but I think you should declare all your refences. If you're copying worksheets I do not ...
Late to answer but what I wanted did not work as you, Velouria, pointed out. My tests resulted in a xlam that is triggred from within the Personal...
Maurizio, You say you want to see the first day of the WEEK of the desired month but this is the first dat of the MONTH. March 2024 starts on a ...
Set the first legget in gggg as Ggggg ?
Resfresh all is for pivot tables and other data, not in a macro like you asked
Hi, simple way to do it is to declare a global variable In the VBA project module you declare a Global boolean variable Global isBusy As B...
If you have actually read what others have answered then you will hopefully undestand why the images are not loaded on the different systems. It ha...
As far as we all can see her, evething, theree's nothing in your post 😉
Hi, My first idea I would suggest a helper column but If you're using Excel 365 or 2021 you can use embedded filter functions oer even sumifs fu...
And what's the problem? Are you requesting a review of the entire thing? Which version (of Excel0 are you using now? If it's understanding how t...
I was working on the same idea, I added two columns CHECK "1" and CHECK "11" Take a look, the desired outcome I have done nothing to that so you c...