Search results 133

Sorted from new to old.

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Range2ANStr

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

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Subtotal_Indirects

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

2021Nov26

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

GenerateThumbnail.php

Generates thumbnail of an image and saving it in certain folder. Edit php to ...

2020Dec24

Generate_PowerPoint

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

2020Dec22

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

CellSave and CellRead

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

2020Oct31

CountDuplicates

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

2020Oct31

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

1 2 ...4 ...8 9