Category Archives: Excel

Excel code to analyze ACSPBLS Data

Posted on July 8, 2009 by clsnyder

Import from the ACSPBLS Site * Introduction Many pediatric surgeons are now storing or will soon be storing a record of their operative cases on the American College of Surgeons Database, located here It is useful to be able to … Continue reading →

Posted in Excel | Comments Off

Convert Excel to HTML

Posted on June 29, 2009 by clsnyder

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 … Continue reading →

Posted in Excel | Comments Off

Excel: Code to search folders and subfolders

Posted on May 18, 2008 by clsnyder

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 … Continue reading →

Posted in Excel | Comments Off

Lisp read in CSV File

Posted on May 5, 2008 by clsnyder

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 … Continue reading →

Posted in Excel | Comments Off

Excel count number of cells of specific color

Posted on September 11, 2007 by clsnyder

Attribute VB_Name = “Module1″ Sub Cell_Color() ‘this module counts the number of cells of given interior color Dim InRange As Range Dim rng As Range Dim wci As Integer Dim cbc As Integer wci = 6 Application.Volatile True Set InRange … Continue reading →

Posted in Computer, Excel | Comments Off