How to add rows and dates on them

[Split4u]

I somehow cant seem to understand what is wrong with this code, i basically want to simply add rows and put dates on them,and the places where i want that is where there is an empty line under it. Dates are going to be simply the next month after the line above.

Here is the code, i get the error of "incompatibility type".(bolded line)

The lines after the blank line are not same type of format(they are not dates, its text or numbers, my guess is that somehow it is linked, because i have tested the sub on a different collumn and it works..

I am not very good at programming, so there are probably a lot of non-logical coding, i dont mind at all if you make another code, but i still would like to know whats wrong with the code.. whatever you guys can do to help, i will appreciate.

thanks a lot.

Please Login or Register  to view this content.

[Greg M]

Hi there,

I think there was just a small typing error in your code, but it caused a big problem!

The following code seems to work for me:

Please Login or Register  to view this content.

The highlighted line shows where the mistake occurred.

You'll see that I included the statement Option Explicit at the top of the VBA module. This is something you should always do. Because I included it before I tried your code, it showed me immediately where the error was. Basically, specifying the option as Explicit requires all variables to be declared in your code, so it will immediately notice any items which have been mistyped as they will not have been declared.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Leith Ross]

Hello Split4u ,

Welocme to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

3. You can also do this manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the line.


As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules