Search results 50

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

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

ToggleCells

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

2025Feb2

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

2024Sep30

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

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

2024Sep23

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

1 2 3 4