Search results 178

Sorted from new to old.

RangeTakePicture_Linked

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

2025Sep30

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

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

Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27

UsedRange

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

2025May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

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

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_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

2025May1

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

2025Mar12

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

1 2 ...11 12