excel-2003

How to count the number of occurrences of all cell values in a specified range

I have an Excel worksheet with one column of cells with any string values, so, like this: A, B, A, D, C, C, A, A. What I am wanting to do is to count how many times each value occurs and print that out on some other cells, like: A:4, B:1, C:2, D:1. I don't mind if these are spread across 2 columns. I also want to order these, with the mo...

Excel merge columns

Hi all I want to merge to columns in excel 2003. For example: Col1 Col2 ------------ 1 5 3 4 4 6 7 6 The merged column should look like this: Col3 ---- 1 3 4 4 5 6 6 7 Thanks!! ...

Catch max time/iteration dialog box when using Excel Solver in VBA

I am using the built-in solver in Excel 2003 within a VBA loop to solver a number of different problems. Occasionally, the solver hits the maximum time or iterations limit, which causes a pop-up dialog box to appear asking whether the user wants to Continue, Stop, or End. In all cases I want it to end, and proceed to the next line of the...

Export SharePoint list to excel doesn't show Version, works in Excel 2003 but not 2007

I'm exporting a list from SharePoint with a particular view (that shows the Version of the item). Exporting to Excel 2003 the list contains the Version column however in Excel 2007 the Version column is missing. Any hints? ...

c# - How to import external data (.csv file) as a new worksheet without opening another workBook/excel application

Hi My target is to open many .csv files, each of them in a new workSheet in the same excel workBook, without opening a workBook for each. I noticed that the Open() or OpenText() methods belong to the workBook class and using them means opening a new workBook. To be more clear, a regular user would simply do this in Excel 2003 by selec...

C# - Excel - how to get the criterias available for the autofilter() method

Hi I want to use the autoFilter() method to filter some rows. I've managed to activate the autoFilter() method on a selected range (the whole sheet) with no problem. The method i use on a selected range looks like this: range.AutoFilter(5, myCriteria, Excel.XlAutoFilterOperator.xlAnd, missing, true); where: 5 is the column index, my...

C# Excel - How to copy the rows filtered by the AutoFilter() method

Hi I've been using the AutoFilter() method with no problem so far. but i wasnt able to mark or get the range of the filtered rows, to count/copy/delete them. I've seen many posts on this issue with VBA, but non for C#. After filtering, i tried to get the range by any of those lines range = ws.UsedRange.CurrentRegion.SpecialCells(Exce...

How to activate a specific worksheet in Excel

I just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet. ...

vba: return dictionary from function

this outlines what i am trying to do. this is not working for me, and it is unclear why. thank you in advance for any and all help. Sub mySub() dim myDict as Dictionary myDict=new Dictionary myDict=myFunc() End Sub Function myFunc() dim myDict2 ...

Optimizing multiple-crtieria IFs

Folks, I'm performing array calculations that are taking a long time to complete. I'd like to optimize my formulas some more. All of the formulas are of the same nature - they perform some high-level function (Average, Slope, Min, Max) across a column of values. However, not all cells in a column are included in the array. I use mul...