Search results 220

Sorted from new to old.

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ChartLegendCenter

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

2023Dec21

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

2023Nov10

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

1 2 ...5 ...13 14