Search results 97

Card image cap
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image cap
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image cap
DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Card image cap
FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

Card image cap
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Card image cap
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Card image cap
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Card image cap
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Card image cap
Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

Card image cap
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

Card image cap
ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...