Search results 82

Sorted from new to old.

SendEmailMsgv2023

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

2023Nov12

End ( xlDown )

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

2023Aug28

SheetTabColor

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

2023Aug17

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

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Range2ANStr

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

2022Jul19

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

ANmaSQL_UpdateDateStatement

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

2022Jul4

1 2 ...5 6