Search results 33

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaSum_4IFs

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

Nov13

ConditionalFormatting_ColorARow

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

Nov10

ANmaRead_1stFile

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

Aug11

gsplit usage

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

Feb7

Grandchildren files and count

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

Jan11

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

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

1 2 3