Search results 141

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

2025Aug7

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

2025Apr27

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

2025Feb2

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

2025Feb2

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

1 2 ...8 9