Search results 36

Sorted from new to old.

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

gsplit usage

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

2024Feb7

Bootstrap 5 cards with responsive images

Bootstrap 5 cards with responsive images From

2023Nov24

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

ReadBinaryBuffer

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

2023Apr30

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Pps vs ppsx

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

2020Dec20

1 2 3