Column Autofit in Excel using macro

 Hello dudes!

Did you ever feel irritated by resizing each column in Excel?👀

Don't worry this post is to solve your problem! Yess this post is about "How to enable column auto-resizing feature in excel using a single line macro (VBA)"

Language : VBA 

Before resizing


Size of column is not consistent with text


Whenever the above problem arises we will be manually adjusting the column right? . But hereafter it wont be the case!

Steps to enable column autofit feature:

Step 1:


- Right click on sheet name and select View Code

Step 2 :



- After getting this window click on the drop-down menu and select Worksheet (which means this code is applicable only for this specific sheet)


- First and last line of the code will be generated automatically , so our work is to type "Cells.EntireColumn.Autofit"


- Click on to excel icon on left corner (which brings you back to sheets)


- Haan Done!


- This code not only resize the columns as per existing data, but the resizing operation (in real time) will be carried out for newly entering data too! 


Step 3:

- Save this file in .xlsm format so that the macro (code which we have typed in) will also be saved.


Hope you all find this post useful . See you all in next post bubye see you . Enjoy Coding dudes!

Comments

Post a Comment

Popular posts from this blog

BMI Calculator using python

Image
 Hello dudes! Long time no see.. Hope you are all doing great😃 After absconding for more than a month we came today to meet you all with a simple python program to calculate your own BMI (Body Mass Index) FYI what is mean by Body Mass Index? Body mass index (BMI) is a simple index of weight-for-height that is commonly used to classify overweight and obesity in adults . It is defined as a person's weight in kilograms divided by the square of his height in meters (kg/m 2 ) . [ If (You think == He might have stolen this definition of BMI from Wikipedia):         You are wrong ]  Hehe😁 actually i have stolen this definition from World Heath Organization So the program is : Explanation : - Height (in cm) and Weight (in kg ) asked from user as inputs in runtime. Here both the variables are declared as float datatype ,which allows decimal values in input. - Unit of height is converted from cm to m - BMI formula with respect to height and weight is defined -...
Read more

Kola pulli pattern in python

Image
 Hello Makkale! Inaiku nama pakaporadhu " How to create digital pulli for digital kolam using Python " in other words " How to create pyramid pattern using python "  Language : Python    IDE : Pycharm  Mangalagarama Pycharm la start panrom Lets dive into the code In the above code, we have initialized the n variable to enter the number of rows for the pattern. We entered n = 5, the range of outer for loop will be 0 to 4. The iteration of the inner for loop depends on the outer loop. The inner loop is responsible to print the number of columns of kolam. In the first iteration, the value of i is 0, and it increased by 1, so it becomes 0+1, now inner loop iterated first time and print one kola pulli (*). In the second iteration, the value of i is 1 and it increased by 1, so it becomes 1+1, now inner loop iterated two times and print two kola pulli (*). The end argument prevents to jump into another line. It will printer the star until the loop is valid. The la...
Read more

Single Line Python Code for Calculator

Image
 Hello dudes! Inaiku nama pakaporadhu - Single line python code for calculator"  IDE : Visual Studio Code Input: print(eval(input ("Enter" ) ) )  ->eval() is an inbuilt function of python ->In this function when we pass any python expression as a “string” , it evaluates the expression and returns the result as an integer or float  -> so indha inbuilt function ah use pani nama single line la calculator pana mudiyum Output: -> Input code ah run panitu, direct ah terminal la poi nama calculations potu enter thandha udane answer vandhurum -> Here we gave 2+3/4*6  and got 6.5 as result -> Ethana mathematical expressions thandhalum BODMAS ( Brackets, Orders, Division, Multiplication, Addition and Subtraction ) rules padi dhan result varum So inike indha code try panunga, eval() use pani vera enalam pana mudiyum nu explore panitu comment la solunga! see you all in next post bybye Enjoy Coding!
Read more