How to read the settings of an Advanced Filter using VBA in Excel The Next CEO of Stack OverflowHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Is there a way to crack the password on an Excel VBA Project?How to avoid using Select in Excel VBAExcel VBA Wrong copy with Advanced FilterAdvanced Filter does not recognize blanks returned by a formulaExcel VBA: Advanced Filtering Blanks Not WorkingAdvanced Filter VBA in Excel, use of ORAdvanced filter errorExcel Advanced Filter only returns header rowAdvanced filter not loading all data when no filters are applied - Excel 2016
Is there a difference between "Fahrstuhl" and "Aufzug"?
Strange use of "whether ... than ..." in official text
Where do students learn to solve polynomial equations these days?
How do I fit a non linear curve?
Defamation due to breach of confidentiality
Is there such a thing as a proper verb, like a proper noun?
How to use ReplaceAll on an expression that contains a rule
Is French Guiana a (hard) EU border?
Is Nisuin Biblical or Rabbinic?
Ising model simulation
Free fall ellipse or parabola?
In the "Harry Potter and the Order of the Phoenix" video game, what potion is used to sabotage Umbridge's speakers?
Is it ever safe to open a suspicious HTML file (e.g. email attachment)?
Is it convenient to ask the journal's editor for two additional days to complete a review?
Does higher Oxidation/ reduction potential translate to higher energy storage in battery?
How can I make proper oatmeal cookies?
Man transported from Alternate World into ours by a Neutrino Detector
Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank
(How) Could a medieval fantasy world survive a magic-induced "nuclear winter"?
Calculate the Mean mean of two numbers
Audio Conversion With ADS1243
My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?
Is fine stranded wire ok for main supply line?
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
How to read the settings of an Advanced Filter using VBA in Excel
The Next CEO of Stack OverflowHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Is there a way to crack the password on an Excel VBA Project?How to avoid using Select in Excel VBAExcel VBA Wrong copy with Advanced FilterAdvanced Filter does not recognize blanks returned by a formulaExcel VBA: Advanced Filtering Blanks Not WorkingAdvanced Filter VBA in Excel, use of ORAdvanced filter errorExcel Advanced Filter only returns header rowAdvanced filter not loading all data when no filters are applied - Excel 2016
I have data in sheet1 (A1:H200), sorting criteria (K1:M4) Now I manually enable the advanced filter (Advanced Filter window) and set the appropriate parameters so that the filtering results are from the K10 cell.
Is it possible to write to variables what is set in the Advanced Filter window using the vba statement ?. I mean options: List range, Criteria range, Copy to, Unique records only, etc.
I can set a new advanced filter using VBA, but I do not know how to read its settings later.
I need this to check students' tasks automatically. Manual checking of what the student did is very time-consuming.
excel vba
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
add a comment |
I have data in sheet1 (A1:H200), sorting criteria (K1:M4) Now I manually enable the advanced filter (Advanced Filter window) and set the appropriate parameters so that the filtering results are from the K10 cell.
Is it possible to write to variables what is set in the Advanced Filter window using the vba statement ?. I mean options: List range, Criteria range, Copy to, Unique records only, etc.
I can set a new advanced filter using VBA, but I do not know how to read its settings later.
I need this to check students' tasks automatically. Manual checking of what the student did is very time-consuming.
excel vba
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20
add a comment |
I have data in sheet1 (A1:H200), sorting criteria (K1:M4) Now I manually enable the advanced filter (Advanced Filter window) and set the appropriate parameters so that the filtering results are from the K10 cell.
Is it possible to write to variables what is set in the Advanced Filter window using the vba statement ?. I mean options: List range, Criteria range, Copy to, Unique records only, etc.
I can set a new advanced filter using VBA, but I do not know how to read its settings later.
I need this to check students' tasks automatically. Manual checking of what the student did is very time-consuming.
excel vba
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
I have data in sheet1 (A1:H200), sorting criteria (K1:M4) Now I manually enable the advanced filter (Advanced Filter window) and set the appropriate parameters so that the filtering results are from the K10 cell.
Is it possible to write to variables what is set in the Advanced Filter window using the vba statement ?. I mean options: List range, Criteria range, Copy to, Unique records only, etc.
I can set a new advanced filter using VBA, but I do not know how to read its settings later.
I need this to check students' tasks automatically. Manual checking of what the student did is very time-consuming.
excel vba
excel vba
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
edited Mar 22 at 7:50
Pᴇʜ
24.9k63052
24.9k63052
asked Mar 21 at 19:09
TonyTony
12
asked Mar 21 at 19:09
TonyTony
12
asked Mar 21 at 19:09
TonyTony
12
12
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20
add a comment |
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20
add a comment |
0
active
oldest
votes
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287672%2fhow-to-read-the-settings-of-an-advanced-filter-using-vba-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287672%2fhow-to-read-the-settings-of-an-advanced-filter-using-vba-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Could you apply the filter using VBA and then you know the settings?
– SJR
Mar 21 at 21:06
Yes, I can, but it's not about me, it's about students. I am a teacher and I check the excel's tasks by students. The tasks are from various topics: e.g. formulas, charts, sorting, filtering .... On average, within a month, I need to check and evaluate about 200 tasks. It takes a lot of time. I am writing a macro in VBA that will facilitate and speed up my work. And for advanced filtering tasks, I check if the student has made the correct filter settings. My macro must read the settings and issue a grade.
– Tony
Mar 22 at 8:20