Search results 246

Sorted from new to old.

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

HTMLPaddingMargin_v2

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

2024Jan5

CutString7

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

2024Jan1

CutLeftNumber

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

2023Dec31

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

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

VBHTMLInstr

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

2023Dec3

SearchinHTMLTable

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

2023Nov12

HMatchIf_Multi

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

2023Oct30

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

1 2 ...6 ...15 16