Search results 61

Sorted from new to old.

punycode

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

Jun8

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

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

ANmaRename2Files

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

Mar16

ConditionalFormatting_Clear

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

2024Nov10

ANmaRead_1stFile

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

2024Aug11

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

2024May31

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

List_of_Names + DeleteNames

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

2023Jul9

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

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

1 2 3 4