Search results 124

Sorted from new to old.

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

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

2021Oct13

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

ANmaCopy_Objects

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

2020Nov11

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

1 2 ...4 ...7 8