Search results 171

Sorted from new to old.

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

Showing 4k (and more) images in BS5 modal

Allow users to browse and scroll through tons of images to select one (tried on ...

Nov7

CountColumnCells_Unique

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

Oct6

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

1 2 ...10 11