Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Excel VBA Macro Excel

Excel VBA For each cell in Range – Direct method

May 28, 2025
Kumarapush

Learn how to loop in Excel VBA for each cell in range of a worksheet. Also get its row, column numbers and values with the loop.

Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

May 28, 2025
Kumarapush

Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.

MS Word VBA Beginners

VBA to open or save Word document Protected or Encrypted with password

May 28, 2025
Kumarapush

Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.

Excel VBA Macro

VBA Get Numbers with in a String

May 28, 2025
Kumarapush

Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.

VBA Array Excel Excel VBA Macro

VBA – Find number of Dimensions in an Array

May 28, 2025
Kumarapush

How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.

Excel VBA Macro

VBA Combo box Add Items – from Excel Range or Array

May 28, 2025
Kumarapush

VBA code to add items to Combobox Userform. Different methods to add combobox dropdown items present in a userform using the VBA code.

Excel VBA Macro Excel

Run Macro from Another Workbook – Excel VBA

May 28, 2025
Kumarapush

Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.

Web Scraping Browser Chrome Excel VBA Macro

Excel VBA Selenium Chrome – Easy Sample Code

May 28, 2025
Kumarapush

Install Excel VBA Selenium type library & launch Chrome browser for webdata extraction. Also other browsers like Firefox, Edge etc.,

File Operations Data Type Excel VBA Macro

VBA to Change File Encoding ANSI to UTF8 – Text to Unicode

May 28, 2025
Kumarapush

Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.

Excel VBA Macro Excel

How to open VBA in Excel – Macro code editor?

May 28, 2025
Kumarapush

Learn how to open VBA code in Excel. Get different options to open Excel macro code as per steps explained in this article.

Posts pagination

1 2 … 17 Next
Excel VBA Macro Tricks
  • Import Mail IDs from Outlook Email to Excel
  • VBA XML Parser – Read XML Nodes & Import To Excel
  • VBA – Find number of Dimensions in an Array
  • Hyperlinks Index – Get all links with address, cell – Whole Workbook
  • How to Web Scrape with VBA using IE & Parse HTML?
  • How to get Computer MAC Address using Excel VBA?
  • Find Local IP Address – VBA Macro Code
  • Excel Convert – Number To Date – VBA Date Format
  • VBA Msgbox with Yes No Cancel Options
  • Excel VBA – Find String in Range – Return Row – Change Background Color – Remove Duplicates
  • Excel VBA Remove Duplicates Values
  • Not a Secret Anymore – What is my IP Address Location? Bulk GeoIP Lookup
  • Copy Excel Chart in Powerpoint – Macro VBA pastespecial
  • How to Unzip file using VBA – Excel Macro?
  • VBA Hello World – Excel Macro – For Beginners
Excel Tricks
  • VBA Macro Import – Read XML File into Excel – 5 Easy Tips
  • VBA Msgbox with Yes No Cancel Options
  • How to Add Leading Zeroes in Excel – for Numbers?
  • Number of Working Days in a Year – Between Two Dates – Excel
  • Not a Secret Anymore – What is my IP Address Location? Bulk GeoIP Lookup
  • Creating Folders Using Python: A Simple Guide
  • A Simple Guide to Copying Excel Sheets
  • Retrieve All Files in a Directory using Python
  • Creating Folders in Outlook: A Guide
  • Chandrayaan 3 Live Stream Today – Vikram Lander
  • Creating Folders Using Python: A Simple Guide
    As the world of technology continues to advance, it becomes evident that the ability to manipulate, create, and manage digital spaces is of utmost importance. Python programming language is among the most powerful tools capable of such feats. This exciting exploration commences with an introduction to Python, providing essential knowledge […]
  • A Simple Guide to Copying Excel Sheets
    Navigating the intricate landscape of Microsoft Excel can often seem like a daunting task. This software, with its abundance of features, functions, and commands, requires a keen understanding to fully utilize its potential. Whether you’re an industry expert or a novice user, mastering the art of manipulating Excel sheets is […]
  • Retrieve All Files in a Directory using Python
    In our digitally driven world, where data processing and management are integral to many industries, the ability to work with Python has become an invaluable skill. This language, particularly in relation to file and directory manipulation, grapples with the rapid growth of data and its intricate handling. With its intuitive […]
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved