Search results 16

Sorted from new to old.

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Max + Min

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

2019Dec31

ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

2018Nov25

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9