How to Use ChatGPT to Create Macro VBA in Excel | Excel Tips & Tricks #shorts

#excel #excelshorts #skill91

Autofit the whole sheet using ChatGPT, a cool trick to show off.

Steps to Follow:

"Step 1: Open Chat GPT and write a prompt like ""Write a VBA code to Autofit Rows and Columns in Excel""
Step 2: Copy the code it writes and come back to Excel worksheet.
Step 3: Right click on Sheet 1 from left bottom corner and go to View Code.
Step 4: Right click on Left panel and Insert a Module. Paste the code there and close the VBA editor.
Step 5: Press 'Alt +F8' and Locate the Macro and press run. The Data in Cells is autofit. "

😍 Why Choose Excel Club By Neeraj Arora? 😍

✅ 155+ Detailed pre-recorded videos highlighting every feature & function of Excel.

✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access

✅ 380+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel

✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.

✅ Real-life use cases of excel that you can use in your job, business, or internship

✅ Certificate from Skill91 that you can highlight in your resume

✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 12500 students who are learning excel with you RIGHT NOW!

Wondering about validity?

Don't worry. Each enrollment is valid for a SOLID 365 days!

No matter if you're a student, professional, or just looking to get started on MS-Excel

Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.