Search results 36

Sorted from new to old.

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

Jan8

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

2024Nov13

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

Shape_Select_or_CreateThenSelect

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

2022Jul21

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

Window and screen sizes in jQuery

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

2021Mar18

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

1 2 3