Similar codes
ConcaUFO_RowsfromSheets
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
SheetAdd_ANmar
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
WorkbookClose_ANmar
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Frm9 - Select workbook (or workbook/worksheet)
Gives your user ability to select a workbook from list of open workbooks within ...
2019Apr3
WorkbookOpen_ANmar
Opens Workbook without running AutoMacros and without letting the user know ...
2018Jun16
IsThere1_SPWB
Checks if a workbook is found in a SharePoint location or not, giving a full ...
2020Apr1
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
ShortenDir
Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...
2020Feb19
This Year
A quick JS way to get the year of today, a method found it online, and wanted ...
2018Dec16