Search results 149

Sorted from new to old.

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

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

2021Dec27

Subtotal_Indirects

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

2021Nov26

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Row_PixelLocation

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

2021Feb2

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

CountDuplicates

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

2020Oct31

1 2 ...5 ...9 10