Updating(Adding) new rows in a table using MACRO

[ddyy]

Hi,

I am trying to add new rows at the bottom of a table using a macro.

This is how I was taught before.

1. Select and copy the row.
2. go to the table to which you wish to add the new row.
3. click the top-left cell in the table and press Ctrl+downward arrow to get to the very bottom.
4. (+use relative references) Press downward arrow once again to reach the bottom blank.
5. Paste the value.

This was simple enough.

The trouble at the moment is that this macro works only if the table getting updated is not empty.
If the table is empty, the above macro will result an error.

Could you tell me how to update a new row even when the table is completely in the beginning, using macro?

 

[venkat1926]

not clear

in an empty or even filled sheet the followings code takes you the last row plus one. try experiment this


cells(rows.count,"A").end(xlup).offset(1,0)

 

[ddyy]

To be clear on my issue,

#	Street Name	Unit	Code	Name	Tel #	Remark	City	Province	Postal Code
15	Holmes Ave			D Chang	416-512-xxxx		Toronto	ON	M2N 4L8

<colgroup><col><col><col span="2"><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

I wish to copy and paste that row (15 Holmes...etc.) onto a separate table with the exact same headings.

#

Street Name

Unit

Code

Name

Tel #

Remark

City

Province

Postal Code

<colgroup><col><col><col span="2"><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

I will keep adding new rows at the bottom of that table.

Could you write me a macro? I am terribly new at Macro.