Similar codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
InSheet_ChangeImage
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
ShapeName clicked
Simple command to know which object (shape) the user clicked When you assign a ...
2022Feb4
ForegroundColor
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
May5
Shapes-Macros
Read shapes in all worksheets in certain workbook and return list of macros ...
2018Jul9
Save Excel range (or shape) to picture
This is an interesting approach to export a range of cells into picture using ...
2020Dec21
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Random GUID
Generate a random GUID using oracle db workbench Also add timestamp to ensure ...
2019Dec22
UnMergeFill
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
StringFlip
Flips a string, right-to-left, and if passed again, will flip it back Can be ...
2018Jun2
List of options (Frm87)
Show list of items with their description from "Settings" sheet Have that list ...
2018May17