Search results 40

Sorted from new to old.

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

May25

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

Apr2

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

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

1 2 3