Similar codes
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
CountColumnCells + CountColumnCells_Criteria
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
DynamicFill
Fills in more rows at end of a range Used to add more rows at end to have all ...
2022Mar11
ArrayRead + ArraySave
Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...
2018Apr15
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
Random Codes
UnUnixDateTime
Convert a number represents a date in Unix format back into date, opposite of ...
Jan6
Zoomed iframe
Show iframe zoomed or in scale
Thanks to
Aug4
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
strUnQuote
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3