Search results 169

Sorted from new to old.

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Sun 4AM

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

CountNumbers_inString

Returns how many numbers found inside a text

Aug1

DecimalPlaces

Returns how many decimal places the number have

Jul24

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Jul13

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

Steps Recorder Win10 app

Win10 application already found in Windows. to generate list of steps with ...

Feb16

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Feb14

gsplit usage

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

Feb7

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Jan28

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

1 2 ...10 11