Similar codes
Max + Min + Min_No0s
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
VBInstr_Numeric
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
.jpg)
RoundMinutes
Rounds time into nearest quarter up or down, half up or down based on argument ...
2019Jan9
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
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
DialChart - Excel-VBA
A dial chart inside Excel using VBA code. With options to show 3 areas and two ...
2019Apr27
XLShortcut_EnableDisable
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
ASCII_Read + ASCII_Save
Reads and saves text file giving its full name Used a lot in my tools, very ...
2018Apr21