MyDev

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

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

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

2023Dec2

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

2023Nov28

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

2023Nov20

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

2023Nov5

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

2023Nov1

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

2023Oct24

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

2023Oct13

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

2023Oct7

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

2023Sep1

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

2023Aug28

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

2023Aug21