Search results 60

Sorted from new to old.

Shapes_HideShow

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

Sep30

punycode

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

Jun8

Non-English IDNs

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

Jun4

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

FilesIn_4Array

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

May25

ANmaRename2Files

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

Mar16

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

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

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

2024Feb25

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

AddressReferenceStyle

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

2023Nov1

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

1 2 3 4