Search results 60

Sorted from new to old.

Range2ANStr

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

2022Jul19

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

1 2 3 4