Search results 182

Sorted from new to old.
Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
ANStrFind_AndOrAdd

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

Card image
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Card image
ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

Card image
MathInsideANString

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

Card image
ReplaceStrings

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

Card image
GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

Card image
HMatchIf_Multi

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

Card image
ANmaFilter3

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

Card image
USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

Card image
End ( xlDown )

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

Card image
FilesIn_Array and FoldersIn_Array

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

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
ListPivotsInfo

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

Card image
ANmaHTMLImgDownload

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

Card image
IfFoundInList

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