Similar codes

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

Card image cap
ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

Card image cap
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

Card image cap
LXFormat

Formats a number found at end of string to have additional leading zeros to ...

Jun30

Card image cap
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

Card image cap
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

Card image cap
BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

Oct25

Card image cap
UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

2018Jun26

Card image cap
OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

Mar5

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

May25

Card image cap
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Card image cap
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

Card image cap
FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6