Prantick Bala

About author

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.



Rhino3D, Maxsurf, C++, MS Office, AutoCAD, WordPress and Excel & VBA


  • Intern at Khulna Shipyard, Khulna, Bangladesh.
  • Probationary Officer at United Commercial Bank PLC, Bangladesh.

Latest Posts From Prantick Bala

How to Set Print Area in Excel (5 Methods)

Print area specifies a range of cells from an Excel worksheet which will be printed instead of the total sheet when you give the command to print. It is a ...

How to Link Excel Workbooks (4 Effective Methods)

Sometimes you need to link one Excel workbook with other workbooks to import data or to use in a formula. In this article, I’ll show you 4 effective methods to ...

Cannot Insert Column in Excel (All Possible Causes with Solutions)

In Excel, you may need to insert a column for adding new data. But sometimes you cannot insert a column in Excel in spite of your needs. In this article, I’ll ...

Excel Hyperlink with Shortcut Key (3 Uses)

Sometimes you may need to refer to a web page for the data you’ve used in your Excel sheet. Hyperlink in Excel allows you to visit a web page or external ...

How to Highlight Active Row in Excel (3 Methods)

If your Excel dataset has a lot of columns, it becomes quite difficult to find data from one end to another end of a row. But if you generate a system in which ...

How to Remove Panes in Excel (4 Methods)

Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to remove ...

How to Remove Header and Footer in Excel (6 Methods)

Header and Footer contains different information of a document such as chapter name, author name, page number, publisher logo etc. in the top and bottom of ...

How to Use VBA LTrim Function in Excel (4 Examples)

Excel VBA LTrim function removes leading space from a string. This function is used to develop a Macro to remove leading spaces from a specific text. By the ...

How to Use VBA Randomize Function in Excel (5 Examples)

VBA Randomize function is an inbuilt Math or Trigonometry function of Excel which allows you to change the seed value used by the random number generator of ...

How to Use VBA Val Function in Excel (7 Examples)

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the starting ...

[Fix] The Pivot Table Name Is Not Valid (7 Causes with Solutions)

Sometimes you may face the error box saying that “The Pivot Table field name is not valid” when you are creating a Pivot Table. In this article, I’ll show you ...

Create Table in Excel Using Shortcut (8 Methods)

A table in Excel allows you to perform different calculations and organize your data more easily. You can create a table in Excel in different ways. In this ...

Create Depreciation Schedule in Excel (8 Suitable Methods)

Depreciation describes how an asset's value decreases over time. A Depreciation Schedule is a table that displays the amount of depreciation for a fixed asset ...

Hotel Bill Format in Excel (Create with Easy Steps)

Hotel Bill format is an invoice format which you can use to create hotel bills for clients in order to document information about hotel services as well as ...

Excel COUNTIFS Not Working (7 Causes with Solutions)

Excel COUNTIFS function counts values that match one or more criteria from a range. You may sometimes face the issue that the function is not properly working. ...

Browsing All Comments By: Prantick Bala
  1. You are welcome, Adam. Feeling happy to know that this article has solved your problem.

  2. Thanks dar for finding the article helpful.
    Would you please share your Excel sheet?
    Then I’ll be able to understand what you are actually want to do and try my best to give you a solution.

  3. Hello Paul,
    I hope you have found your solution already. If not, please share your Excel workbook with me. It is difficult to say the reason for the error message without seeing your worksheet or code. I will try my best to solve your problem.

Advanced Excel Exercises with Solutions PDF