This question is actually for the Excel GUI, rather than Excel "programming", per se. However, if this is unavailable in the GUI, I would be curious if there's a VBA solution (although, I...

I have a column with values like the below sample: Size 4 1*4 1*24 4*1 4.5*10 2*14*5 3*4*5 I need to set a filter to get the cells contains the specific number e.g "4&q...

I use the code below to search and replace a part of a text in a string. It works fine for almost 97 % of the replacements but not when one string that is supposed to be replaced is identical with ...

How do I use Apache POI to pre-define an auto-filter region in an Excel 2007 document? A small code example or link would be nice.

How do you find the last row of data when the data in your worksheet is filtered? I have been playing around with Special Cells and Visible Cells but cannot find a solution. I think it must be some...

In the continuing saga of my data analysis (First Question), I want to delete all the rows whose departments (Field 7) are not 101, 102 or 103 (the names have been changed to protect the innocent)....

I notice my VBA script doesn't work when there's an autofilter already on. Any idea why this is? wbk.Activate Set Criteria = Sheets("Sheet1").Cells(i, 1) Set rng = Sheets("Sheet1").Range(Cells...

I am using an AutoFilter with VBA in Excel that works for regular filters, but not a column formatted as date. I can filter it manually. If I run my code, it filters nothing but when I check the f...

I've inherited some VBA code that attempts to save and restore filters in Excel 2010-2016 (I'm testing on Excel 2016 - 32bit, 16.0.4549.1000). I've already learned this is pretty much impossible to...

Background: Since recently I came to know about a secret named range that gets created through using AutoFilter. Usually (if not always) this is called "_FilterDatabase". I thought about playing ...

Background: For many times I have applied AutoFilter and never really asked myself why it works the way it does sometimes. Working with the results of filtered data can be confusing at times, espe...

issue : my code always return one row instead of 13. Code: Excel.Application xlApp = null; Excel.Workbook xlWorkBook = null; Excel.Worksheet xlWorkSheet = null; Excel.Range xlrange = null; strin...

Okay, here's my dilemma. I've been working on a Wordpress plugin for Medical Marcom to automatically update his List of US Twitter Doctors. Basically, it provides the ability to create a form wher...

First time poster here :). I'm having the following trouble automating Excel 2010 from a WinForms C# application. My test table looks the following way: Index Value1 Value2 AAA 2 3 AAA 3 4 AAA 3 ...

I am trying to filter a range of values and based on my criteria, at times I might have no data that fits my criteria. In that case, I do not want to copy any data from the filtered data. If there ...

All, I am trying to filter on multiple criteria within VBA. However I cannot find a simple way of doing this. The criteria I am selecting will always be constant but greater than 2 therefore I c...

Thanks for coming to this thread. What I have: -A report with an autofilter on rows A:G What I need: -Circumstantial code that unfilters a specific column if there is a filter on it. -Running...

Right now I am doing coding to set a filter for a data chart. Basically, I don't know how to post the data sheet up here so just try to type them ): (starting from the left is column A) Name * BDe...

how to add button [x] to clear auto filter so we dont need to press delete or backspace clear the filter. illustration like this for the code iam using for repositoryitemcombobox private void ...

I've searched other posts and found similar issues but nothing that could help me specifically. I'm trying to take an array of strings and use it as a filter criteria. It's tricky because the array...

Despite the number of questions on this topic I haven't been able to find the resolution to my issue (which may or may not be my fault). I need to autofilter a range to return blanks and numbers b...

I have been looking for a way to filter an Excel spreadsheet with more than two wildcards. I asked on StackOverflow previously if I could put more than two wildcards in to AutoFilter in VBA directl...

After trying in vain to set more than 2 criteria in a normal AutoFilter fashion via VBA, I have come to learn that it must be done via advanced filter. offending example: Worksheets(1).Range("A1"...

I am trying to extract Autofilter parameters using VBA. Can any one help me with getting the Autofilter parameters, specifically when a date Autofilter is applied? E.g. Say you have a table with tw...

I have been searching for a while, and haven't been able to find a solution as yet. This question has been asked before on here but the OP didn't get a response and I didn't want to resurrect an o...