Don't know if you're still interested in the file but I limited the file to the minimal tables and extra's I left the searchfilter sheet but it's no...
Taking a look at the code you've got an overkill of unnecessary data Searbox sheet, Data sheet and the Dynamic sheet is something I do not knwo why y...
I suggest you take a look here. This link tells you about the different fileformats and will give you an idea how to handle your question
The code you've written (or copied or whatever) is a mess. No logic whatsoever, the dropdown list in IN-OUT does not make sense There's a long way t...
I honestly don't knwo what you have done but the size of the values in the Userform is out of bounds. Furthermore the code is, if I may say so, very ...
Hi Rik, Aside from uploading the file I also suggest you update your profile telling us which Excel (Office) version you're using
When you look at the form size it's set to huge width and height. Question of redesigning the userform and if needed use the zoom function. Nothing ...
The userform is not resizing the userform settings are set to this size. It's very bad coding and the error, well that's another issue. O yes, and w...
Hi Michael, Thanks for the trust but don't expect we can 'see' what you're doing by just asking a question. An attachment with dummy data without ex...
Hi, quite some time ago I fund this code snippet. I save what I find as text files The link where I found it is in the attached file and all you nee...
Sub VBARenameFileSheetNames() '* Sytax is: FileCopy sourceFullName, newFileName FileCopy ActiveSheet.Range("C2") & ActiveSheet.Range("C4") ...
@Mynda: is VSTACK reserved to Office 365? My Office 2021 does not recognize VSTACK()
XLOOKUP will only work if the OP's version of Office is 365 or 2021 and newer
I struggled many times with columns where I wanted dates in tables. The solution that helped me was to leave the new column as default of as text a...
How are you referencing the named ranges in your formula?