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

August 31, 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

August 31, 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

August 31, 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

August 31, 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

August 31, 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

August 31, 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

August 31, 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

August 31, 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

August 31, 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?

August 31, 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
  • Safe Password Manager – Secure All Your Passwords
  • Excel Vba RGB to Hex,Long – Hex to Rgb,Long – Color Code Conversions
  • Making SORT More Simple and Faster in Excel with Advanced Options
  • How To Insert Command Button – In Excel Sheet – Developer Tab?
  • Convert CSV to Vcard File – Download Converter App
  • How to Delete Blank Rows in Excel – Remove Empty Rows – 3 Easy Tips
  • Convert Excel to HTML Table Tags – VBA Macro Code
  • Import Mail IDs from Outlook Email to Excel
  • Domain to IP – Find Website IP address from URL
  • Excel VBA Delete Folder if Exists
  • How to Convert Excel to Access Database?
  • Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook
  • Convert Excel to Jpg Image – VBA Code
  • VBA Option Explicit Not Working – Solved
  • Excel VBA Get Stock Price – Google Finance – Best Live Stock Ticker
Excel Tricks
  • VBA Userform – Escape key to Close – Unload form
  • Queues Interface in Java
  • Python Program To Check Palindrome
  • Import Mail IDs from Outlook Email to Excel
  • Excel VBA Check – IF String Contains – Only Letters
  • 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