Search results 65

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

ShapeDelete

Safely remove certain shape from worksheet

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

CSS Generators

One of my newest friends in css styling, tons of options. Love the simple ...

2025May22

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

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

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

2025May4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

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

1 2 3 4 5