Thanks for you kind help, I have one small correction, the current code is like if there is particular date the rows will insert, but I will show you the example: 01.01.2018 and the next row is 04.01.2018 but I have cutoff date is 02.01.2018, but it is not there in column E, if I enter the Date as 02.01.2018 it should not show the "Please try again", I need to insert rows between the 01.01.2018 and 04.01.2018.

Before I answer your latest question, please allow me to offer a posting tip. I hope that you will accept this tip in the spirit that it is intended, which is to let you know how you can make it easier for people to help you.

Please keep in mind that we cannot see your workbook from where we are sitting nor do we know anything about your work processes. The only thing we have to work with is what you tell us in your posts. When working on a solution, we often have to set up test worksheets using the data layout that you describe in your posts. In this example, when you tell us that "Column E has date range from 01.01.2018 to 31.01.2018" and that you want rows inserted when a specific date is entered by a user, that's all we know, so that is all we have to work with. We spend our time coming up with a solution to meet those requirements. When you come back later with additional (or different) requirements, we have to rework our solution, set up the test sheets again and sometimes even start from scratch. Please try to be as specific and as detailed as possible when you first post your requirements.

That said...

I want to make sure that I understand your latest requirements before I proceed.

In the example given in Response # 4, it appears that you want to start with this:

I'm not sure why you marked the thread as Solved if you haven't received a working solution yet. I have reset the Best Answer choice.

Try the following code. Note: I see that you are using a Date format of dd.mm.yyyy. My system uses mm/dd/yyyy and I do not want to change my Regional settings or default Date format just to test the code. It messes up my real work.

This should work, but obviously I can't test it under your operating environment, so you'll have to let me know. If it doesn't work, please don't come back and just say "It doesn't work". That will not help me figure out what is wrong. Tell me exactly what happens (or doesn't happen) including any error messages that you get.

The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Compnet Ventures, LLC hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.