MyDevLib

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

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

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

2020Nov11

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21