Search results 943

Sorted from new to old.

CountRowCells

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

Jun22

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

ANmAdd_ThenSort_2Columns

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

Jun1

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

May27

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

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

1 2 ...5 ...58 59