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
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
ApplyValidation_DropDown
Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...
2018Aug10
Textbox focus issue fix
Trick to force textbox with multiple lines and scrollbars to refresh itself ...
2018Jul29