Similar codes

Card image cap
CopyFormat

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

2018Aug10

Card image cap
Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

Dec27

Card image cap
CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Aug10

Card image cap
Register OCX in 64 and 32 bit

Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.

2020Feb9

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

Card image cap
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

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
File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

Card image cap
CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

Card image cap
DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

Card image cap
GetExtension

Gets the extension of file from its filename

2018May12