Search results

Dear Habib Thanks for thanking me. Your appreciation means a lot to the ExcelDemy Team. I am delighted to hear that you have resolved a new issue on your own. I agree with you that "VBA is a crazy and interesting language at the same time." A Friendly Suggestion: Please post your new problem...

Wa alaykumu s-salam Habib You are most welcome! Let me know how your project is going. Regards Lutfor Rahman Shimanto

Dear Vera Welcome to ExcelDemy Forum! I am doing fine, thanks for asking. You have mentioned the formula you are working with now always returns a #N/A error. The reason behind the #N/A error is the wrong placement of comparing Year with the values of D22:G22 ($B$15=$D$22:$G$22). I am...

Dear Habib I hope this post finds you in good health. I am delighted to inform you that I have developed a sub-procedure to fulfil your new requirement. As requested, the code will store the gap values and do other color-formattings within sheet3. I had to add other variables named ws3 and...

Wa alaykumu s-salam Habib Thanks for staying with ExcelDemy Forum. It is to be mentioned that your appreciation means a lot to us. I am working on your new requirement: placing the gap values on sheet3. When I am done, I will share the idea on this thread. Regards Lutfor Rahman Shimanto

Dear Habib I hope this post will find you in good health. I have gone through the attached file that you shared in a conversation with me. Thanks for posting with such clarity. I have learned the specific requirements easily. I am delighted to inform you that I have developed an Excel VBA...

Wa alaykumu s-salam Haas You are always welcome, and your appreciation means a lot to us. Regards Lutfor Rahman Shimanto

Hello Haas I went through the attached file. You wanted to put R instead of 0 if there are no gaps between the colored cells. I have made a few changes to return R instead of 0 and overcome other issues. RESULT OF GAP or WHITE CELLS BETWEEN COLORED CELLS Excel VBA Code: Sub...

Dear Haas Thanks for Thanking. After seeing the project, I will let you know whether I can do it alone or not. Currently, I am going through the issue that arises with the sub-procedure responsible for calculating the Gap between the colored cells. When I am done, I will share the idea here...

Wa alaykumu s-salam Haas Thanks for your nice word. Your appreciation means a lot to us. May Allah bless you as well. We are always here to assist. So do not hesitate to reach out any time. Regards Lutfor Rahman Shimanto

Dear Haas As requested, I am working with Source Data, which has 6498 rows and 232 columns. As a result, the execution time will be more than the usual running time. 1. RESULT OF SUM or COUNTS OF COLORED CELLS Excel VBA Code: Sub CountAndColorCellsPQR() Dim ws1 As Worksheet Dim ws3...

Dear Haas I have reviewed the attached file you gave. After Investigating the file, I noticed that your requirements are below: Requirement 1: 232 Columns. and 6498 Rows of DATA. Digit length is 01 to 10,999. All calculations are done on each column Requirement 2: Ignore Blanks Requirement 3...

Wa alaykumu s-salam Haas It's great to hear from you again. No need to apologize at all! My family and I are doing well. Thank you for asking. Currently, I am going through the specifications you have given in your attached file. When I am done, I will share my findings in this thread. Stay...

Hello BigMe Thanks for posting your comment with such clarity. Based on the cell values of column A, you want to create or clear a drop-down list in the corresponding cells of column B. I am delighted to inform you that I have developed such an idea that will fulfil your requirements. To do...

Dear Bryan The error you were having was because one of the sheets among sheets 1, 2, and 3 was missing. Things to Remember: Ensure that all the sheets 1, 2, and 3 exist in your workbook. Regards Lutfor Rahman Shimanto

Hello Bryan Thank you for posting your query with such clarity. After analyzing the new requirement, I understand that you want to clear contents from the merged cells within the B31:P47 range for sheets 1 and 2. For sheet 3, the code will remove contents from the merged cell within the...

Hello Bryan Welcome to ExcelDemy Forum! Thanks for reaching out and posting your query. You want to clear data from merged cells on 3 different sheets in the same workbook. The range for sheets 1 and 2 is B31 down to B47. Sheet 3 is from B37 to B47. I am delighted to inform you that I have...

Hello Bino1121 Thanks for reaching out and describing your problem with such clarity. You are right about the bold section of your given codes, which raises an error while running. Because you're not properly defining the ranges you want to use in the AdvancedFilter method. I am delighted to...

Dear BigMe Thanks for your queries. You want the value of Global Variable using the input method, but when you use other modules, it always asks me to input again. I am happy to share the idea of keeping the value based only on the first input so that when you run the next module, Throughout...

Hello Vipinpanchal2008 Thanks for reaching out and posting your query. You are unable to insert images using names. Besides, you cannot fit the inserted images within merged cells. I am delighted to inform you that I have developed an Excel VBA sub-procedure to fulfil your requirements. Unlike...