MD. ABDUL KADER is an engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SWM, GIS, RS, and SPSS. He holds a B.Sc in Urban & Regional Planning from Chittagong University of Engineering and Technology and has shifted to become a content developer. In this role, he crafts technical content centred around Excel and VBA. Outside the professional realm, catch him immersed in books, exploring new places during travels, and watching movies.
When you have a tiny dataset, it’s easy to find the row number, but in the case of a larger dataset, you may have to use the ROW function. In this article, ...
The NOT function in Excel returns a logically opposite value. In this article, you’ll learn to use this function and also discuss its application with VBA ...
The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss how to use the TRUE ...
If you are looking for Excel WEEKDAY function, then you are in the right place. The WEEKDAY function is especially handy for planning, scheduling, and even ...
The MINUTE in Excel is a built-in function that is classified as a Date/Time function. It can be found on the Formulas tab of the Ribbon. In this article, I’ll ...
Sorting implies rearranging data to get a better visual presentation of your dataset. It is such a powerful tool that can organize text, numbers, and dates. In ...
Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits Number and ...
The article will show you how to use OFFSET Dynamic Range for multiple columns in Excel in effective ways. Dynamic range expands automatically when you update ...
We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row in Excel. In this article, I’ll discuss the five ...
Comparing text in two columns in Excel is a significant task in our daily lives, especially when we have to find something that compares to the given text. In ...
When working with data sets that contain dates, you may need to sum the values based on the provided date regularly. SUMPRODUCT is one of the versatile ...
Finding the lowest value may be an essential task in some cases. We can easily do those tasks with the help of Microsoft Excel. Have you tried this basic ...
In some cases, we have to find the date after incrementing 1 month. Do you know the easiest ways and functions to do that? In this article, I’ll focus on how ...
You may attach a special type of number like 1 before the local phone number of the US to make it an international identity. It is also mentionable that the ...
The SUMIF function is widely used in Excel for calculating the sum value of a single range based on a given criterion. But it is also possible to apply SUMIF ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Hello EAC,
Thanks for your question. Most likely, you need to put a not equal sign (<>) inside the If…Then statement of your second code. So, the corrected second code will be as follows-
However, your used three codes are quite messy. I would like to suggest that you can use the following code to lock a specific cell range in all worksheets of your Excel file.
Again, try this code to unlock the specific cell range in all worksheets.
I hope these will work! Moreover, you can follow lock and unlock cells using VBA to explore more efficient methods.
Hello Michael,
Please specify your problem in detail or send the excel file via [email protected] email address.
Dear Deka,
It’s nice to hear from you with such wonderful appreciation. I myself always try to represent Excel applications in a more user-friendly way. And we, the ExcelDemy team, are working as a one-stop Excel solution provider.
Thanks, and take care of yourself. Goodbye!
Md. Abdul Kader
Editor, ExcelDemy.