Search results 55

Sorted from new to old.

RangeTakePicture_Linked

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

2025Sep30

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

Custom Excel UI ribbon

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

2025May11

ANmaUploadFTP_FilesListto1Folder

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

2025May1

Match6_Until

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

2024Nov28

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

WinXP css theme

CSS theme to show page as windows style, this one is WinXP

2023May30

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

1 2 3 4