Insert Row into the range under specific condition

Hello, Dear Members!

I kindly ask you help me on this issue. Please find attached file.

Here you will find Workers and their working years. I need to add new line for worker when his/her working year finished. For example when the date > 17.07.2018 I need to add new line for John. (date = today formula)

It look like simple but this is a part of my vacation module.

I started to write code like this and when I run it I got compile error for "MyTable". I can't find out issue.

Please Login or Register  to view this content.

Here is how I would do that:

Please Login or Register  to view this content.

The easiest thing to do (for me, at least )is convert your table to a range, run the macro, and convert the range back to a table.

Hi Medex

In future please view the forum rules before posting. Your post does not comply with rule #3.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
So, do the following:
Edit your post, highlight your code and click the [#] button at the top of the post window.


With that been said...Try this method...tests fine...

Please Login or Register  to view this content.

............................................
Thanks.gif