Search results 172

Sorted from new to old.

Hack VBE password in .xlsm

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

2025Dec30

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30

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

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

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

2025May22

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

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

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

1 2 ...10 11