Search results 104

  2. Search results
  3. Object
Sorted from new to old.
Card image
ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27
Card image
Hiding chart in Excel

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

2020Dec31
Card image
Save Excel range (or shape) to picture

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

2020Dec21
Card image
ANmaCopy_Objects

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

2020Nov11
Card image
ExitTool and DoNothing

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

2020Oct31
Card image
CountDuplicates

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

2020Oct31
Card image
SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11
Card image
JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30
Card image
FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20
Card image
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14
Card image
DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1
Card image
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31
Card image
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24
Card image
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21
Card image
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20
Card image
IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

2020Jan10
123...67