Browse codes

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

Gets the cell row where a certain shape is located by passing shape.Top number ...

Tue Feb2 11AM

Returns sum of certain column in range (or table) in sheet after applying ...

Fri Jan29 11AM

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Tue Jan12 9AM

List of all variables of Environ It will populate them in sheet range starting ...

Tue Jan12 9AM

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

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