Browse codes

Search results 78

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

Mon Aug22 11AM

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

Wed Aug17 9AM

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

Thu Jul21 8AM

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

Tue Jul19 3AM

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

Wed Jul6 10AM

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

Fri Apr22 12PM

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

2021Dec27

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

2021Nov26

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

2021Nov26

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

2021Jun13

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

2021Feb2

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

2020Dec24