Category Archives: Excel
Excel code to analyze ACSPBLS Data
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
Convert Excel to HTML
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
Excel: Code to search folders and subfolders
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
Lisp read in CSV File
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
Excel count number of cells of specific color
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