Codes Required
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
GetColumnName, ColumnName_XOffset
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
CopyRowHeight
Copy row height from row to another Used to fix row heights or merged cells to ...
2019Aug1
Add2Column
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
RowsCount
Get total number of rows for a certain worksheet in certain workbook workbook ...
2018Jun22
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
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
2020Apr14
