Search results 239

Sorted from new to old.

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

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

1 2 ...6 ...14 15