MyDevLib

VBA-Excel 250 Visual basic for applications that works only in Microsoft Excel, aka macros

Adds to daily log, two cells, one with date, next with activity that will be ...

Dec2

Adds date to column1 when user enters text in column2. Also, if user remove ...

Nov28

Perform math on numbers inside list of numbers in format of ANString. ...

Nov20

Sppecial version to convert HTML to string. Uses RemoveHTML, then after that ...

Nov5

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

Nov1

Finds the number between two spaces that is found close to of Word1Location ...

Oct24

Filter database into new sheet, by copying certain columns only, not whole ...

Oct13

Return a range of cells in column where ... Return Range Ignore header ...

Oct7

Fix for Excel VBA error when library not found. Screenshots should show how to ...

Sep1

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Aug28

Checks if a number found between two characters, searching can be customized to ...

Aug21

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Aug17