Search results 58

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

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 vertical shimmer placeholders

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

2025May25

MatchIf4Up

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

2025Apr12

Match6_Until

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

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

Center Userform

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

2024Jul23

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

1 2 3 4