Similar codes
Hiding chart in Excel
How to hide a full chart in Excel. By treating it as shape, not as chart.
2020Dec31
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
InSheet_ChangeImage
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
ShapeName clicked
Simple command to know which object (shape) the user clicked When you assign a ...
2022Feb4
ForegroundColor
Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...
2023May5
Shapes-Macros
Read shapes in all worksheets in certain workbook and return list of macros ...
2018Jul9
Save Excel range (or shape) to picture
This is an interesting approach to export a range of cells into picture using ...
2020Dec21
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
Refresh Table from View
Convert SQL View into table for speed reading. Using views a lot, I needed a ...
Jul19
Dynamic iframe height
Adjust iframe height to its content after loading page Needed this trick in ...
2023Apr29
Bootstrap 4 cheat sheet
Bootstrap 4 cheat sheet, quick direct link as image
2019Apr9
