Search results 50

Sorted from new to old.
Card image
ReNumber_IDColumn_inTable

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

Card image
ReplaceStrings

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

Card image
AddressReferenceStyle

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

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
Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

Card image
ListPivotsInfo

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

Card image
ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

Card image
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

Card image
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Card image
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...