↓ Skip to Main Content

Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Category: VBA and Macro

Lesson#182: Color all empty cells in red in a selected range with VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#182: Color all empty cells in red in a selected range with VBA

Here I shall show you a VBA code that colors all empty cells in red in a selected range. Here is a VBA macro that you can use to insert zeroes in all empty cells in a selected range: To …

Lesson#182: Color all empty cells in red in a selected range with VBA Read more »

Lesson#181: VBA To Add A Prefix to Selected Cells

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#181: VBA To Add A Prefix to Selected Cells

Here is a VBA macro that you can use to add a prefix to the selected cells: To use this macro, select the cells to that you want to add the prefix and run the macro. It will prompt you …

Lesson#181: VBA To Add A Prefix to Selected Cells Read more »

Lesson#180: How do you copy a color from one cell to another?

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#180: How do you copy a color from one cell to another?

Here we shall learn a code that will copy a color from one cell to another using VBA. Here is a function in VBA that you can use to copy the interior color of a target cell to the active …

Lesson#180: How do you copy a color from one cell to another? Read more »

Lesson#179: Count cells by color in Excel from a reference cell color with VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#179: Count cells by color in Excel from a reference cell color with VBA

Here I shall make a VBA code to Count cells by color in Excel from a reference cell color. Here is a function in VBA that you can use to count the number of cells in a specified range that …

Lesson#179: Count cells by color in Excel from a reference cell color with VBA Read more »

Lesson#178: Delete all blank sheets with VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#178: Delete all blank sheets with VBA

In this article, I shall give you a VBA code that will delete all blank sheets at once. Here is a VBA program that will delete all blank worksheets in the active workbook: To use this code, open the Visual …

Lesson#178: Delete all blank sheets with VBA Read more »

Lesson#177: Insert blank rows in Excel after every row in the sheet with VBA

By Puspendu Roy Karmakar Posted on December 27, 2022 Posted in VBA and Macro
Lesson#177: Insert blank rows in Excel after every row in the sheet with VBA

Here we shall discuss how to Insert blank rows in Excel after every row in the sheet with VBA. Here is a Visual Basic for Applications (VBA) code snippet that you can use to insert a blank row after every …

Lesson#177: Insert blank rows in Excel after every row in the sheet with VBA Read more »

Lesson#176: Insert rows within a range with VBA

By Puspendu Roy Karmakar Posted on December 27, 2022 Posted in VBA and Macro
Lesson#176: Insert rows within a range with VBA

To create a program in Visual Basic for Applications (VBA) that inserts a specified number of rows after every row in a specified range, you can use the following code: This code defines a subroutine called InsertRows that takes a …

Lesson#176: Insert rows within a range with VBA Read more »

Lesson#175: 15 common questions about VBA answered

By Puspendu Roy Karmakar Posted on December 27, 2022 Posted in VBA and Macro
Lesson#175: 15 common questions about VBA answered

VBA is a programming language used in Microsoft Excel to make spreadsheet problems more easily. This can solve spreadsheet problems more easily but learning VBA needs time and patience. In this article, we shall find out answers to 15 common …

Lesson#175: 15 common questions about VBA answered Read more »

Lesson#174: How to make a New year Countdown Timer in VBA

By Puspendu Roy Karmakar Posted on December 27, 2022 Posted in VBA and Macro
Lesson#174: How to make a New year Countdown Timer in VBA

Hello readers! The new year 2023 is on the way. But do you know how to make a new year countdown timer in VBA? Let’s discuss this Topic. To create a countdown timer in Visual Basic for Applications (VBA) that …

Lesson#174: How to make a New year Countdown Timer in VBA Read more »

Lesson#173: Steps to make a Custom function in VBA

By Puspendu Roy Karmakar Posted on December 25, 2022 Posted in VBA and Macro
Lesson#173: Steps to make a Custom function in VBA

You can create a Custom function in VBA in Microsoft Excel by following these steps: For example, to create a function called “MyFunction,” you would type the following: For example, to create a function that adds two numbers together, you …

Lesson#173: Steps to make a Custom function in VBA Read more »

Posts pagination

Previous 1 2 3 4 5 Next
Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2025 Excelabcd | Powered by Responsive Theme
Loading…