How to format a row of cells based on the string value of a reference cell.
– Read More –
Excel
Excel VBA: Replace Images (Shapes) Locked To Cells With Text
November 7, 2015
This is some code that will replace an image/shape that is locked to a cell with text. – Read More –
Excel VBA – Create iCalendar file
March 16, 2015
This is some code to create an iCalendar (.ics) file from data in cells – Read More –
Using Excel Solver In VBA
June 24, 2014
Here is a routine that shows how to use Solver within VBA. – Read More –
Convert Excel Named Range To Local Scope
June 24, 2014
Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope. – Read More –
Excel VBA – RGB to HSV Color Conversion
March 11, 2014
VBA function to convert RGB values into OpenCV HSV values. – Read More –
Excel VBA Curve Fitting
April 5, 2013
These are some curve functions that can be used to generate curve fits to data that doesn’t lend itself to the built in Excel curve fits. – Read More –