Can any one please help:
I have a table name Table1.
Please help me write code to add 10 rows count form the last table row. And on column B, please help me fill on series number. B7 is always start with number 1. My table have a lot of rows. please help me with save time code.
Thank you very much
I have a table name Table1.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | ||||||||||
3 | ||||||||||
4 | ||||||||||
5 | ||||||||||
6 | NUMBER | NAME | DAY | |||||||
7 | 1 | |||||||||
8 | 2 | |||||||||
9 | ||||||||||
10 | ||||||||||
11 | ||||||||||
12 | ||||||||||
13 | ||||||||||
14 | ||||||||||
15 | ||||||||||
16 | ||||||||||
Sheet1 |
Please help me write code to add 10 rows count form the last table row. And on column B, please help me fill on series number. B7 is always start with number 1. My table have a lot of rows. please help me with save time code.
Thank you very much