Search results 60

Sorted from new to old.

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

Apr2

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

ConditionalFormatting_ColorARow

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

2024Nov10

ANmAddressSame

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

2024Sep24

HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

2024Aug19

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

OrderedList in Arabic Alphabet

Using Arabic in ordered list in HTML, as Abjad or Alphabet. Was playing with ...

2024Feb25

HTML_CleanNumber

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

2024Jan31

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Excel user name

Get application user name or change it Originally from

2023Jun14

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

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 4