Search results 95

Sorted from new to old.

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

AddDatabar_ConditionalFormatting

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

2022Aug22

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

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

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

RowList_Matching

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

2021Dec27

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

ToolPath

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

2021Jan12

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

ANmaCopy_Objects

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

2020Nov11

1 2 3 ...5 6