Search results 51

Sorted from new to old.

Subtotal_Indirects

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

2021Nov26

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

File2Body

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

2020Dec15

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

Screenshot_IrfanView

Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

2019Jun27

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

2019Apr27

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

2018Nov25

ImagesIn

Just like FilesIn function, but this one returns list of images only found in a ...

2018Nov24

1 2 3 4