Hi all,

The sheets are single letter A to G on sample workbook, A to Z in
real workbook.

I did not submit the code: For i = Asc("A") To Asc("G").

Another question, please.

Summary sheet has a Table, which seems to me to be column A. I can
go to name box and Table1 is listed.

If I click on Table1 it hi-lites column A.

All columns are filtered (has the drop down arrows).

Are there common rules on how to copy to a table as we are here. I
anticipate some problems here. If you delete the data in the
table/filtered area, the next copy goes to the first empty row below
the table. That could be 50 + rows down.

If you delete all the data filled ROWS of the table, then you have
the Headers and a empty 1st row of the table, and the copy goes to
the first row below that empty table row.

Perhaps, the table and filter should be "Turned Off" and old data
deleted, to leave a row of Headers, then do the copy, then reinstate
the table and filter???

Howard

The *Table object* is problematic for coding (IMO) because this object
has its own rules, and is primarily used for data analysis scenarios,
not for storing raw data. You have to delete the table to remove it.

When writing new data to a summary sheet, filters should be turned off
so inbound data is correctly positioned. Filtering shouldn't really
matter since the rows are contiguous in col1 (or should be) since the
1st col usually contains the *PrimaryKey* in database tables. (I think
it's a good practice to follow the rules<g)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion