How to format a row of cells based on the string value of a reference cell.
– Read More –
How to format a row of cells based on the string value of a reference cell.
– Read More –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 –
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 –