Search results 118

Sorted from new to old.

Subtotal_Indirects

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

2021Nov26

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

RandomUniqueID_Sheet

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

2021May29

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

CellSave and CellRead

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

2020Oct31

Graphbar

Interactive graph bars, will go deeper when you click on the bar Originally ...

2020Aug16

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

CopyRowHeight

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

2019Aug1

ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

2019Jun26

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

This Year

A quick JS way to get the year of today, a method found it online, and wanted ...

2018Dec16

1 2 ...6 7 8