Search results 50

  2. Search results
  3. a1
Sorted from new to old.
Card image
ReNumber_IDColumn_inTable

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

2023Dec17
Card image
ReplaceStrings

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

2023Nov11
Card image
AddressReferenceStyle

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

2023Nov1
Card image
ANmaFilter3

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

2023Oct13
Card image
USB Format in Car stereo

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

2023Sep29
Card image
End ( xlDown )

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

2023Aug28
Card image
Thin HTML5 Coming soon Template

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

2023Aug19
Card image
ListPivotsInfo

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

2023Aug13
Card image
ScanFolder

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

2023Apr7
Card image
Excel recovered files

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

2023Mar31
Card image
Range2Block

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

2023Mar6
Card image
ANStr2Range

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

2022Nov11
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
ANmaBatchCreate + ANmaBatchRun

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

2022Aug25
Card image
HyperlinkFunction

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

2022Aug24
Card image
LastRow_Remove

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

2022Aug16
1234