Similar codes
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Excel clipboard bug
Looks like there is a bug in Excel when dealing with copy and paste. Excel ...
Dec27
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
CopyDynamicRangeValue
Copy values from range to cell. Without using clipboard of course. Here the ...
Aug10
Register OCX in 64 and 32 bit
Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.
2020Feb9
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
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
FilterSheet_1By1 + FilterSheet_Clear
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Max + Min + Min_No0s
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31
OpenOffice Calc
OpenOffice programming with Visual Basic Some document I had for my reference.
2019Jan5
