Search results 525

Sorted from new to old.

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

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

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ListPivotsInfo

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

2023Aug13

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

CopyDynamicRangeValue

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

2023Aug10

1 2 ...10 ...32 33