Search results 53

Sorted from new to old.

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

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

1 2 3 4