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
This is some code that will replace an image/shape that is locked to a cell with text. – Read More –
This is some code to create an iCalendar (.ics) file from data in cells – Read More –
Here is a routine that shows how to use Solver within VBA. – Read More –
Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope. – Read More –
VBA function to convert RGB values into OpenCV HSV values. – Read More –
Here are a few methods for reading/writing text files.
– Read More –A macro for creating named ranges in a spreadsheet. The generated names are local in scope. – Read More –
A VBA sub routine for batch renaming/moving/copying of files. – Read More –
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 –