Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Excel Tricks
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
  • Number of Working Days in a Year – Between Two Dates – Excel
  • Mortgage Calculator – Loan EMI Scheduler – in Excel
  • Calculate Excel Date Difference in Days – Get Simple Formula
  • Get List of All Subfolders in a Folder – Excel VBA
  • How To Insert Command Button – In Excel Sheet – Developer Tab?
  • VBA – Find number of Dimensions in an Array
  • Excel VBA – Copy Workbook – Active or External
  • Compare Two Columns Excel – Highlight Match – Bulk Data Duplicates
  • How to Add Leading Zeroes in Excel – for Numbers?
  • Password Protect Excel 2010 & 2007
  • Excel VBA change selection in Dropdown
  • VBA Convert Excel range to JPG Image
  • Excel VBA – Create Defined Name Formula & How to Use
  • 2 Methods To – Remove #N/A Error in Excel – Vlookup
Color Tricks
  • How to Disable Images in Firefox, Chrome, IE?
  • How to make every other Row or Column shaded in Excel?
  • Excel Vba RGB to Hex,Long – Hex to Rgb,Long – Color Code Conversions
  • How To Sort by Color in Excel?
  • Excel VBA – Get RGB Color of Cell – Change Background
Excel VBA Macro Tricks
  • Clear Excel VBA Immediate Window – Macro Code
  • Convert Excel String To Date – VBA Date Format
  • VBScript Extract Data – Xmlhttp Web Scrape – Parse HTML
  • Disable Autofilter Excel VBA – Filter Switch On OFF
  • How to Create Data Table Excel?
Excel Color Excel VBA Macro

How to do Spell Check in Excel?

June 07, 2025
Kumarapush

How to spell check in Excel? Easy steps to invoke checkspelling module in Excel cell, range, worksheet or word thru menu and VBA Macro,

Bitcoin Facebook Finance

Libra – Facebook Cryptocurrency

June 07, 2025
Pooja

What is this Facebook Cryptocurrency & when is it going to be available. More news about how Libra is going to be launched for public & payment systems.

Cmd Prompt Network

List available Wifi Networks & change Connection

June 07, 2025
Kumarapush

Get cmd prompt command to list available networks in your computer wifi connection. Also get command to change to any of the preferred wifi networks of your choice.

Duplicates Color Excel

Highlight Duplicate Values in Excel with Color

June 07, 2025
Kumarapush

Learn how to highlight duplicate values in Excel using the conditional formatting. Also the formula to find duplicate entries in a Excel range.

Duplicates AutoFilter Excel VBA Macro

Excel VBA Remove Duplicates Values

June 07, 2025
Kumarapush

Get code in Excel VBA to Remove Duplicate values from Worksheet Range or Column etc., This code uses the Excel’s built in Remove duplicates option

Google Spreadsheet Duplicates Google Google Scripts

How to Remove Duplicates in Google Sheets?

June 07, 2025
Kumarapush

Learn how to remove duplicates in Google Sheets using these simple formula. One will simply remove the duplicates & other will give unique records count.

Web Scraping Excel VBA Macro Network Security

How to Web Scrape with VBA using IE & Parse HTML?

June 07, 2025
Kumarapush
0

Get VBA code to web scrape using IE & then parse HTML data from website. The extracted website data is Parsed within Excel VBA code itself.

Python

Get list of Installed Packages in Python

June 07, 2025
Kumarapush
0

Python program to Get list of installed Packages or modules using pip. Also get the cmd prompt command to get the list using pip commands.

Color Conditional Formatting Excel Formula Tricks

How to make every other Row or Column shaded in Excel?

June 07, 2025
Kumarapush
0

Learn how to make every other row shaded in excel. Alternate Rows/Columns background color can be set using conditional formatting, VBA & by inserting table

Network Excel VBA Macro System Control

How to get Computer MAC Address using Excel VBA?

June 07, 2025
Kumarapush

Get VBA Code to find the MAC address for a computer. This VBA code will list the MAC Address of all the network adapters installed in your computer.

Posts pagination

Previous 1 … 19 20 21 … 50 Next

The news you may have missed

January 3, 2023

Excel VBA For each cell in Range – Direct method

April 17, 2022

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

April 6, 2022

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

April 1, 2022

VBA Get Numbers with in a String

November 21, 2021

VBA – Find number of Dimensions in an Array

November 16, 2021

VBA Combo box Add Items – from Excel Range or Array

  • 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