VBA HACKS | ALIGNMENT | ADVANCE EXCEL TUTORIAL | EXCEL AUTOMATION
VBA HACKS- TOPIC ALIGNMENT
Advance Excel Tutorial By Excel Automation- Mudit Lalwani
In this macro code I list out four different scenarios in which you can use VBA to automatically determine what your column widths should be.
Objective
To showcase how to use (1) Autofit (2) change column width and row height (3) merge cells (4) Wrap text
Approach
In this VBA Excel automation, we shall showcase row and column autofit, wrap text, and merge cells on the sample cells shown below.We have executed all these codes on sheet1 of macro file.
Autofit
If we find the width of a row or column to be disproportionate, then we can change it by using autofit property. As we can see in the image on left below that 2nd row had disproportionate height as compared to data, while column B and C had width which was more than the length of the text contained in these columns. Now once we have executed the VBA code, we can see that height of row 2 has been changed, while width of column B and C has also been changed..
My previous videos-
1.Inventory Management Software In Excel | VBA | Userform
• Inventory Management Software In Exce...
2.Date Picker In Excel | Insert date Via calendar | 3 Min Task | VBA Excel
• Date Picker In Excel | Insert date Vi...
3.Automatic Index With Dynamic Hyperlink | Excel Automation
• Automatic Index With Dynamic Hyperlin...
4.How To Create MS WORD Document From Excel | Excel Automation | Mudit Lalwani
• How To Create MS WORD Document From E...
5.Make Snip tool in Excel through VBA | 5 Mins Challenge | Advance Excel
• Make Snip tool in Excel through VBA |...
6.Make E-mail App with Excel using Excel | Valentines day special
• Make E-mail App with Excel using Exce...
7.Userform iN Excel | Data Add | Search | Update
• Userform iN Excel | Data Add | Search...
8.Convert Handwritten Notes (Any language)/ Photos To MS Word
• Convert Handwritten Notes (Any langua...
9.Automating-MIS Reports, Consolidations & Dashboards | Just A Single Click | SQL
• Automating-MIS Reports, Consolidation...
10.Automation-Email Reminders From Excel Through Outlook | Excel Automation | Mudit Lalwani
• Automation-Email Reminders From Excel...
11.Learn Basic Macros In Just 5 Min | Excel Automation | Mudit Lalwani
• Learn Basic Macros In Just 5 Min | Ex...
12.How I saved 1000 Hours in MIS reporting | Excel Automation | SQL In Excel | Dashboard #EXCEL #SQL
13.My Excel Speaks | Advance Excel Tutorial | Excel Automation
• My Excel Speaks | Advance Excel Tutor...
#EXCEL #MUDIT_LALWANI #EXCEL_AUTOMATION #VBA
• How I saved 1000 Hours in MIS report...