Search results 69

Sorted from new to old.

ANmaCellFormat

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

2024Apr18

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

2024Jan31

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

UserChanged_Log4

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

2023Nov28

AddressReferenceStyle

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

2023Nov1

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

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

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Range2Block

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

2023Mar6

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

ANStr2Range

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

2022Nov11

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

1 2 3 4 5