Similar codes
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
CalcArea
Calculates the area of objects. Pass formula argument as string and values as ...
2018Jul24
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
ConcaUFO_RowsfromSheets
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
ReadBinaryBuffer
Reads file in binary mode as blocks Starts reading from start in sequential ...
2023Apr30
Restore Arabic text files
Solution to restore ASCII Arabic text files. Sometimes I noticed when system ...
2019Jan14
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17