• If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk. If you have any questions regarding an article, please use the Article Discussion section.

VBA and Macros

Top Excel articles

This article shows a method to determine the convex hull for a set of points.
0.00 star(s) 0 ratings
Updated
How to get date format as expected when converting text to date
0.00 star(s) 0 ratings
Updated
Copy only the visible cells of a source range to only the visible cells of a destination range.
0.00 star(s) 0 ratings
Updated
This is an implementation of the gift-wrapping algorithm.
0.00 star(s) 0 ratings
Updated
This article shows techniques to manipulate TS functions and Excel shapes.
0.00 star(s) 0 ratings
Updated
This article shows how to manipulate tables with TypeScript.
0.00 star(s) 0 ratings
Updated
This version offers a user interface for fine tuning
5.00 star(s) 1 ratings
Updated
A macro to copy-paste from visible cells to visible cells that is available on any open workbook
0.00 star(s) 0 ratings
Updated
Change Sensitivity Label Azure Company Policy VBA Macro
0.00 star(s) 0 ratings
Updated
This version allows for pictures and two-colored boxes
5.00 star(s) 1 ratings
Updated
This article calculates the path of a ricocheting object inside a closed 2D area.
0.00 star(s) 0 ratings
Updated
This article provides a way to add two colours together
0.00 star(s) 0 ratings
Updated
This article provides code to generate a kind of chart that Excel does not offer
0.00 star(s) 0 ratings
Updated
This article shows how to list parents and children that form the structure of Web pages.
4.00 star(s) 1 ratings
Updated
This article shows six different ways to draw a flag.
0.00 star(s) 0 ratings
Updated
A simple method of taking a PNG or full-page PDF snapshot of a webpage
0.00 star(s) 0 ratings
Updated
VBA: Enhance and speed up random numbers and sorting, using spill functions
0.00 star(s) 0 ratings
Updated
Speed up searching in long list data validation & easy to set various specific behaviors
5.00 star(s) 1 ratings
Updated
VBA Macro to create Word & Phrase Frequency
5.00 star(s) 1 ratings
Updated
A new Rolling Calendar Control as a Date & Time Picker
0.00 star(s) 0 ratings
Updated

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top