Search results 348

Sorted from new to old.

ReplaceStrings

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

2023Nov11

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

HMatchIf_Multi

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

2023Oct30

LEGO UI Controls

Nice CSS-LEGO-UI Controls Originally from

2023Oct16

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

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

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

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

1 2 ...9 ...21 22