New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Excel Macros

Enable Macros in Excel VBA
VBA

4 Easy ways to Enable Macros in Excel VBA

February 17, 2025October 10, 2026 PKComments Off on 4 Easy ways to Enable Macros in Excel VBA
Are you tired of manually repeating the same tasks in Excel? Macros can automate your workflow and save you time! But since macros can pose security risks, Excel disables them
Read More
Create Multiple worksheets
VBA

Macro to Create multiple worksheets from selection

August 16, 2024October 10, 2026 PKComments Off on Macro to Create multiple worksheets from selection
Have you ever found yourself in need of an Excel file with multiple worksheets, each customized to fit your needs? If the thought of setting this up seems overwhelming, don’t
Read More
Add Space in name UDF
VBA

Discover the Magic Excel VBA UDF to Perfectly Space in Names

December 6, 2023October 10, 2026 PKComments Off on Discover the Magic Excel VBA UDF to Perfectly Space in Names
Introduction: The Power of VBA in Excel Excel, a powerhouse in data management and analysis, becomes even more potent with Visual Basic for Applications (VBA). This article will explore how
Read More
Data Sorting using VBA
VBA

Hands-On Guide to Automating Your Excel Data Sorting with VBA

July 17, 2023October 10, 2026 PKComments Off on Hands-On Guide to Automating Your Excel Data Sorting with VBA
Introduction Data sorting in Excel is a common task for many users. However, when you need to sort large sets of data repeatedly, doing it manually can be both time-consuming
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy