Search results 84

Sorted from new to old.

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

2025Nov11

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

punycode

Encode or Decode Punycode used in domain names that are not in English ASCII ...

2025Jun8

Non-English IDNs

Online tool to encode or decode IDNs Domain names with characters other than ...

2025Jun4

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

2025Mar12

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

2025Feb26

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

1 2 ...5 6