Search results 249

Sorted from new to old.

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

1 2 ...4 ...15 16