Search results 78

Card image cap
AddDatabar_ConditionalFormatting

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

Card image cap
DiskDriveType

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

Card image cap
Shape_Select_or_CreateThenSelect

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

Card image cap
Range2ANStr

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

Card image cap
Protecting VBA code

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

Card image cap
BooleanCount

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

Card image cap
RowList_Matching

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

Card image cap
GetColumnIndex

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

Card image cap
Subtotal_Indirects

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

Card image cap
DegreesToXY

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

Card image cap
Row_PixelLocation

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

Card image cap
GenerateThumbnail.php

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