Search results 43

Sorted from new to old.

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

Simple modal with login form in Bootstrap 3

2019Feb8

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

2018Aug10

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

Converts Red, Green and Blue integers into RGB long value

2018Jun2