Search results 531

Sorted from new to old.

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

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

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

PrCal_Add_Sort

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

2023Dec2

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

Between_2Chars

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

2023Nov22

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HMatchIf_Multi

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

2023Oct30

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

ANmaFilter3

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

2023Oct13

Column1Range

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

2023Oct7

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

1 2 ...10 ...33 34