Search results 33

Sorted from new to old.

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

2024Aug11

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

SortArea4

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

2024Apr15

ChartLegendCenter

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

2023Dec21

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

AddressReferenceStyle

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

2023Nov1

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

Range2Block

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

2023Mar6

1 2 3