Search results 584

Sorted from new to old.

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

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

ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

2025May25

CSS vertical shimmer placeholders

Top-to-Bottom and Bottom-to-Top shimmer placeholders in css During my search, ...

2025May25

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

2025May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

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

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

2025Apr17

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

1 2 ...36 37