I have tried a few options but none seem to work, and some send errors. Please let me know what I am doing wrong public string Main(String wbPath, String wbName) { string cName = ""; Excel. I want my Functions() to be fast, efficient and flexible. I vary whether the Function() returns the last used Cell or first used Cell by passing a variable to the SearchDirection by using the values of the xlSearchDirection Enumeration: xlNext and xlPrevious. When the SearchDirection is xlNext, the Function() returns the first used Cell. Full text of "NASA Technical Reports Server (NTRS) 20130008625: Selected Papers Presented at MODSIM World 2011 Conference and Expo" See other formats Depending on the requirements, I'll choose a method for populating my custom collection classes using from data from a worksheet. In this example, I'm using a list of the best selling albums of all time. Filling the collection is just a matter of reading each row and popping the contained values Welcome to the 1940 census. The 1940 census records were released by the US National Archives April 2, 2012, and brought online through a partnership with Archives.com.This website allows you full access to the 1940 census images, in addition to 1940 census maps and descriptions. Application.Calculation = xlCalculationManual. At the end of your code, you can set the calculation mode back to automatic with the statement: Application.Calculation = xlCalculationAutomatic. Remember, though, that when the calculation mode is xlCalculationManual, Excel doesn't update values in cells. [PDF] or denotes a file in Adobe's Portable Document Format.To view the file, you will need the Adobe® Reader® available free from Adobe. This symbol indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Excel builds a "consolidated range" pivot table. If some of the data is non-numeric the data field wou