enumeration

Dear all, I need to resort to your wisdom as I have been struggling half day to work this VBA out. I'm a total amateur in VBA and always resort to already posted codes, so apologies for my ignorance. I need to search in a folder (with subfolders containing several files, including xlsm files...

Is there a way to read UniqueValues.xlDupeUnique enumeration instead of only declaring/assigning it? Thanks y'all.

I am trying to figure out if there is a VBA command/VBA Macro in Excel that from an opened Excel file will retrieve the "file format enumeration information" of the Excel file opened? Specifically, retrieve the following file format enumeration information: file format enumeration name, file...

Dear community, good morning. I am new to this forum and hope you can help me. Here is my problem. Short version: 1. I need VBA to generate all possible combinations following a certain logic 2. Once a new combination is found, this combination needs to be evaluated with a certain function...

Hello there, Does anyone know if there's any way to adjust the <interval> argument of functions like DATEADD according to filter context? The argument takes enumerations, not text strings or numbers that would be easily swapped with some IF logic. At the moment, I'm doing things like this...

The code below may be placed in a Chart codepage. It uses the Status Bar to display information about the part of the graph that is clicked. Moving the mouse clears the status bar. Is there a programatic way to access reverse enumeration of Excel constants, given the area under consideration...