I am asuiming the OP is using Office 365? It doesn't work with 2021 (in my case)
That did the trick !!!
@Velouria: I'm getting a circular reference when the formula is copied acros and only in L19
I also suggest you tell us which version of Excel AND OS you're using,
Maybe I understand your question but I am guessing that you'll have to do this using VBA. Stop and restarting a new sequence will require extensive...
What's the ammount in F5? Oh, and get rid of #VALUE and other errors in formula's makes it look messy
The strange thing is tha every time you refresh the formula the circular reference appears in a different row, if varies. Another thing I don'...
I tested on the Laptop and the same, but why not use a combobox instead of a dropdoen. I changed that in the MainScreens choice, replace the dropdown...
I'd go for macro's but the OP has not answered yet
Okay, I see the issue, I get the glitches on my OS W11 and Office 2021 64-bit too. I'll try it this afternoon on the Laptop W10 64-bit 2010 32-bit an...
strOldNAme does NOT tell you which filetype it is evenb if you selectv the extension Query the filetype, not the extension
I'm not that gerat with formulas but my idea would be a macro or one or more helper columns maybe But since you haven't told us which Office version ...
I cannot test MAC but I do have two systems both 64-bit OS, a Laptop with Windows 10 with Office 2010 (32-bit) and a desktop with Windows 11 and Offic...
My first thought is that the MAC fonts are not the same as the Windows fonts. You cannot compare them.