Search results 137

Sorted from new to old.
Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image
UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Card image
Shape_Select_or_CreateThenSelect

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

Card image
Range2ANStr

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

Card image
Protecting VBA code

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

Card image
BooleanCount

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

Card image
SaveAsHTML_Template

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

Card image
RowList_Matching

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

Card image
GetColumnIndex

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

Card image
Subtotal_Indirects

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

Card image
DegreesToXY

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

Card image
Row_PixelLocation

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

Card image
GenerateThumbnail.php

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

Card image
Generate_PowerPoint

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