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
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
Featherlight.js
A nice and new lightbox, modal, or whatever you call it (version 1.7.13) From ...
2019Jun26
ArrSort_2Arr
Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...
2018Oct1
Shapes-Macros
Read shapes in all worksheets in certain workbook and return list of macros ...
2018Jul9
SharePointURL2Path + Path2SharePointURL
Converts SharePoint URL to regular folder path and the other way, giving the ...
2018Jun30