Search results 44

Sorted from new to old.

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Can't find Project or Library

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

2023Sep1

Enable Includes in ASP Classic

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

2023Aug7

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

O365 Blocked Macros

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

2023Jul10

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

1 2 3