Search results 59

Sorted from new to old.

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Feb25

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

Excel clipboard bug

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

2023Dec27

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

SubZero

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

2023May23

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

2023Apr5

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

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

2022May16

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

1 2 3 4