Similar codes
Sheets to PDF pages
Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...
2018Aug8
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Special chars
How to type special characters in keyboard using ALT + keypad numbers I also ...
2021Oct13
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
Save Excel range (or shape) to picture
This is an interesting approach to export a range of cells into picture using ...
2020Dec21
FixENTERS_File
Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...
2018Jul7
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
WordsOf + Words_Len
WordsOf to create list of words from a block after converting every special ...
2018Jun28