Similar codes
Show/hide ribbon
Show or hide Excel ribbon from inside VBA Needed that in one of my projects
2018Dec30
Loading gif
Show and hide loading gif using Javascript. a simple way to control when to ...
2018Sep23
Row_PixelLocation
Gets the cell row where a certain shape is located by passing shape.Top number ...
2021Feb2
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
ChartLegendCenter
Put chart legend at center of chart horizontally. Changes left and width only. ...
Dec21
Resize_Me2 + Resize_Me3
Resizes Excel window to certain small size and location (hard-coded) and hide ...
2020Dec11
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
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 ...
Apr30
Random Codes
FilesIn_Array and FoldersIn_Array
Return list of files in a folder back as array.
Similar to
Aug15
Copy formulas
How to copy formulas in VBA code. Learned that the hard way, just like most of ...
2019Oct3
ANma_HTML2DB + ANma_DB2HTML + ...
Convert HTML text into DB-safe string, by converting some characters as below. ...
2019Feb7
ANmaVBATemplate
Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...
2018Jul26