Search results 79

  2. Search results
  3. pass
Card image cap
UnixDateTimeNumber

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

Fri Jan6 3PM
Card image cap
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image cap
DiskDriveType

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

2022Aug17
Card image cap
Shape_Select_or_CreateThenSelect

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

2022Jul21
Card image cap
Range2ANStr

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

2022Jul19
Card image cap
Protecting VBA code

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

2022Jul6
Card image cap
BooleanCount

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

2022Apr22
Card image cap
RowList_Matching

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

2021Dec27
Card image cap
GetColumnIndex

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

2021Nov26
Card image cap
Subtotal_Indirects

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

2021Nov26
Card image cap
DegreesToXY

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

2021Jun13
Card image cap
Row_PixelLocation

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

2021Feb2