Search results 54

Sorted from new to old.

Match6_Until

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

Nov28

Match4_Until

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

Nov22

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Nov17

Excel 2408 bug

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

Sep10

ANstr_Column

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

Jul29

ANmaSpecialFolders

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

Jul26

Center Userform

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

Jul23

ANmAdd_ThenSort_2Columns

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

Jun1

ListBox bug with TabIndex

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

Apr15

SortArea4

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

Apr15

MatchIfUp or MatchIfRev

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

Apr8

Concatenate_HTMLColumn

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

Mar14

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Jan28

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

1 2 3 4