This is some code that will replace an image/shape that is locked to a cell with text.
Tag: VBA
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.
Visual Basic/VBA – Working With Text Files
Here are a few methods for reading/writing text files.
Auto Create Excel Named Ranges
A macro for creating named ranges in a spreadsheet. The generated names are local in scope.
VBA Batch File Rename
A VBA sub routine for batch renaming/moving/copying of files.
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.