Search results 61

Sorted from new to old.

Excel clipboard bug

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

2023Dec27

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

2023Aug19

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

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

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmaBatchCreate + ANmaBatchRun

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

2022Aug25

Protecting VBA code

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

2022Jul6

ANmaSQL_InsertStatement

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

2022Jul3

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

1 2 3 4