Search results 61

Sorted from new to old.

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Sun 9AM

Shapes_HideShow

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

2025Sep30

punycode

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

2025Jun8

Header font name and size in VBA

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

2025Jun1

FilesIn_4Array

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

2025May25

ANmaRename2Files

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

2025Mar16

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

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

Excel user name

Get application user name or change it Originally from

2023Jun14

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

1 2 3 4