Codes Required
Similar codes
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Range2Block
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
CellSave_Hyperlink
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
CellRead (SimpleLookup)
Simply reading a value from a specific cell from a sheet from a workbook ...
2018Jun25
SwitchTextinCells
Switch text inside cells with another text. This was needed to correct an bug ...
Feb23
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Boxed Shadow2
Pure CSS shadow effect A Pen created at CodePen.io. You can find this one at ...
2019Jan17
ASCII_Read + ASCII_Save
Reads and saves text file giving its full name Used a lot in my websites, very ...
2018Jun21
BrowseWorkbook + BrowseWorkbook_Save
Asks for Excel file to open, then return the full filename with path if ...
2018Jun16
DB_Setting1List + DB_Setting1List_NameValue
DB_Setting1List is to Returns list of SettingValues matching certain ...
2018May31