How to format a row of cells based on the string value of a reference cell.
Tag: Excel
Excel VBA: Replace Images (Shapes) Locked To Cells With Text
This is some code that will replace an image/shape that is locked to a cell with text.
Excel VBA – Create iCalendar file
This is some code to create an iCalendar (.ics) file from data in cells
Using Excel Solver In VBA
Here is a routine that shows how to use Solver within VBA.
Convert Excel Named Range To Local Scope
Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope.
Excel VBA – RGB to HSV Color Conversion
VBA function to convert RGB values into OpenCV HSV values.
Excel VBA Curve Fitting
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.