need help to add a new row to a table automatically

[hereisjohny]

Hi there, i am new to vba coding and i need some help with a code i made.
I am trying to build a code that will add a new row to a table automatically if the current month is greater then the newest month that is currently in the table
for example if the latest row shows info for December 2019 than the code will add a new row for January 2020. here is the code i made:

Please Login or Register  to view this content.

When i try to run it, it says
"run time error 13:
type mismatch"

and highlights the if function line...

Please if anyone can tell me what i am doing wrong it will be of great value to me!!

[Marc L]

Hi,

the right syntax order is Cells(Row#, Column) as explained in the VBA inner help …

[sintek]

Please Login or Register  to view this content.

As per Marc L ... the n represents row, the 1 represents column
https://www.wallstreetmojo.com/vba-cells/

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I did it for you this time

[hereisjohny]

As per Marc L ... the n represents row, the 1 represents column

yeah the row index is the variable...
it is supposed to look for the last row in the table and if the month in that row is smaller then the current month then it will preform the code inside the if loop..

[sintek]

When i try to run it, it says
"run time error 13:
type mismatch"

Please Login or Register  to view this content.

See the correct code in post 3