tagged [excel]
filter out multiple criteria using excel vba
filter out multiple criteria using excel vba I have 8 variables in column A, 1,2,3,4,5 and A, B, C. My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But wh...
- Modified
- 15 Nov at 10:2
Convert date field into text in Excel
Convert date field into text in Excel I have an Excel file which has a column formatted as date in the format `dd-mm-YYYY`. I need to convert that field to text. If I change the field type excel conve...
- Modified
- 25 Feb at 23:32
Remove Duplicates from range of cells in excel vba
Remove Duplicates from range of cells in excel vba I'm trying to remove duplicates in excel 2013 VBA. but I'm getting error "object does not support this property or method". The problem is I don't ha...
- Modified
- 25 Jul at 21:17
How to use workbook.saveas with automatic Overwrite
How to use workbook.saveas with automatic Overwrite In this section of code, Excel ALWAYS prompts: "File already exists, do you want to overwrite?" ``` Application.DisplayAlerts = False Set xls = Crea...
- Modified
- 2 Jun at 08:51
Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running? The following code leaves a Microsoft Excel background process running, until after my program has exit...
- Modified
- 7 Oct at 05:20
microsoft.interop.excel Formatting cells
microsoft.interop.excel Formatting cells I am building a report using the microsoft.interop.excel library in C#. I have something like this: I want the range to display its values as whole numbers i.e...
- Modified
- 13 Sep at 12:38
Get the current Workbook Object in C#
Get the current Workbook Object in C# I've been writing an application in C# which creates Custom Document properties in an Excel spreadsheet, I have a function for this which takes in a Workbook Obje...
Find last used cell in Excel VBA
Find last used cell in Excel VBA When I want to find the last used cell value, I use: I'm getting the wrong output when I put a single element into a cell. But when I put more than one value into the ...
- Modified
- 27 Jul at 11:23
Excel Date to String conversion
Excel Date to String conversion In a cell in Excel sheet I have a Date value like: I want to convert that Date to Text and also want the Text to look exactly like Date. So a Date value of `01/01/2010 ...
- Modified
- 29 Mar at 06:48
Shortcut to Apply a Formula to an Entire Column in Excel
Shortcut to Apply a Formula to an Entire Column in Excel If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells...
- Modified
- 14 Jun at 15:57
Add user defined function to Visual Studio Excel Add-in
Add user defined function to Visual Studio Excel Add-in In visual studio I have an Excel 2010 Add-in project. How can I have that project create the following module:  on a range of cells, and where the contained value is a date, to increment the counter - essentia...
- Modified
- 6 Mar at 14:16
Loop through each row of a range in Excel
Loop through each row of a range in Excel This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to rememb...
- Modified
- 8 Jul at 20:13
Excel: last character/string match in a string
Excel: last character/string match in a string Is there an efficient way to identify the last character/string match in a string using base functions? I.e. not the last character/string the string, ...
- Modified
- 17 Jun at 22:22
How to keep one variable constant with other one changing with row in excel
How to keep one variable constant with other one changing with row in excel Lets say I have one cell A1, which I want to keep constant in a calculation. For example, I want to calculate a value like t...
- Modified
- 25 Jan at 21:58
Getting unique values in Excel by using formulas only
Getting unique values in Excel by using formulas only Do you know a way in Excel to "calculate" by formula a list of unique values ? a vertical range contains values `"red"`, `"blue"`, `"red"`, `"gre...
- Modified
- 10 Sep at 10:51
How to SUM parts of a column which have same text value in different column in the same row
How to SUM parts of a column which have same text value in different column in the same row I have a column with names and a column with numbers: Names with same `FirstName` a
- Modified
- 28 Sep at 23:9
Draggable data points in Excel 2007?
Draggable data points in Excel 2007? I know Microsoft removed draggable points in 2007, but I need to get that function back. So far, I've got the MouseDown and MouseUp events trapped, but I'm having...
- Modified
- 9 Jul at 18:41
Ignore cells on Excel line graph
Ignore cells on Excel line graph I am trying to draw a line graph in Excel 2010. The y column data source has some gaps in it and I want these to be ignored for the graph. Seems to default these to ze...
- Modified
- 19 Aug at 15:48
Find if column contains value from another column?
Find if column contains value from another column? I have two columns. Column E extends up to 99504 (values) and column I extends to 2691 (values). Both columns contains filenames with extension. Some...
- Modified
- 29 Jan at 12:9
Excel 2010: how to use autocomplete in validation list
Excel 2010: how to use autocomplete in validation list I'm using a large validation list on which a couple of vlookup() functions depend. This list is getting larger and larger. Is there a way to type...
- Modified
- 27 Jun at 14:48
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp? I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the...
- Modified
- 9 Jul at 18:41