Search results 18

Sorted from new to old.

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

CopyFiles Excel-Macro

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

2024Mar12

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

2024Feb10

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

Timeline css

CSS Timeline, simple, easy, nice piece from bootsnipp From

2023Nov14

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ReadBinaryChunk

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

2023Apr28

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

CopyFiles

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

2022Feb3

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

CSS Charts

Great articel about making charts in CSS. It has 3 main types, bar, column, ...

2020Feb1

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

1 2