VBA to populate Table

[sintek]

Hi All

For once and for all I need to get assistance to understand this concept. I have attached my workbook.
This code populates the Table and then moves down to next row...It however only populates from 2 row.

Please Login or Register  to view this content.

If I change this line of code

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

it populates the first row but on the next populate it overwrites the existing code
There must be a way to add something like this

Please Login or Register  to view this content.

to make it populate the first row and then the second third etc

[Ron Coderre]

Since you're using an Excel Table....You should take advantage of its features.

Try something like this:

Please Login or Register  to view this content.

Also....you should ALWAYS have "Option Explict" at the top of every VBA Module to prevent inadvertent, on-the-fly, variable delarations and usage.

Is that something you can work with?

[sintek]

Oh My word Ron

Thanks so much... It's as if a weight has been lifted off my shoulders.
Do you perhaps have a helpful link I can read up on Tables.

What do you mean by :

to prevent inadvertent, on-the-fly, variable delarations and usage.

[Ron Coderre]

Option Explicit

That statement acts like a spell-checker in your VBA code. If you misspell a variable name...
example:

Please Login or Register  to view this content.

The code will compile, but will throw an error when you run it because Wks was never actually set.
If Option Explict was used. Running Debug.Compile from the menu would flag Wksht as an error.

If you're looking for a great website to learn how to used VBA on Excel Tables, you can't do much better than Jan Karel Pieterse's site:
http://www.jkp-ads.com/Articles/Excel2007TablesVBA.asp

I hope that helps.

[sintek]

Ron you've been an absolute star. Am gonna go on the site to read up.
A Quick question. You will notice by the below code that i have adapted it for the bigger Picture.

Please Login or Register  to view this content.

I need this part to be added:

Please Login or Register  to view this content.

Would that be the correct syntax

[Ron Coderre]

If it works....then YES

You might even be able to use something like this: (untested)

Please Login or Register  to view this content.