Search results 70

Sorted from new to old.

End ( xlDown )

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

2023Aug28

bootstrap 5 Spacelab Dark

A Bootstrap 5 css and scss, Spacelab, dark after modified. Not a toggle, just ...

2023Aug12

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

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaBatchCreate + ANmaBatchRun

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

2022Aug25

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

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

1 2 3 4 5