5 Best VBA Macros | VBA to Excel
ฝัง
- เผยแพร่เมื่อ 29 ม.ค. 2023
- These are the 5 best VBA macros that you can use right away, to save you time and hassle on Excel.
Find the macros here: vbatoexcel.wordpress.com/
List of Macros:
1. Removing Duplicates (getting unique list of items on a separate sheet)
2. Delete blank rows easily.
3. Find the last used row in any list.
4. Save sheet as a PDF file.
5. Create custom formulas for Excel.
Music : Bensound
#exceltips #exceltricks #ExcelFun #excelgames #exceldashboard #excelchart #exceltutorial #shorts #excelmacros #automation #vba
#VBA #Macros #Excel #Productivity #Automation #MicrosoftExcel #Office #Programming #ExcelMacros #TechTips - วิทยาศาสตร์และเทคโนโลยี
Really good content. 5 macros in 1 short is always a win for me. Thanks.
To save as PDFs
You could also click F12, tab, P, Enter
The pdf save can also be made to save itself in a specific folder and with a specific name. The name can be set from cells within the table. I have one that saves itself with the excel file named followed by the job number from another cell, project name from another cell and item name from a third cell.
Just think of what you want excel to do and ask ChatGPT for a VBA code to do it.
Subscribed with first short!🙋
You have to make the video on advance vba functions to explore vba coding
Really like your videos, any chance you could make a longer video and include the code ?
Please visit my website for the code. vbatoexcel.wordpress.com
Keep uploading important information
I will try my best
I hope so!
Please slow video
Which font is this? Can someone help pls
It’s the Monaco font…