This is some code that will replace an image/shape that is locked to a cell with text. – Read More –
Excel VBA: Replace Images (Shapes) Locked To Cells With Text
November 7, 2015
VBA
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 –
Visual Basic/VBA – Working With Text Files
April 10, 2013
Here are a few methods for reading/writing text files.
– Read More –
Auto Create Excel Named Ranges
April 10, 2013
A macro for creating named ranges in a spreadsheet. The generated names are local in scope. – Read More –
VBA Batch File Rename
April 9, 2013
A VBA sub routine for batch renaming/moving/copying of files. – 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 –