Copy Data And Paste To Another Workbook

[HaroonSid]

hi,
i am using this code to copy paste data from one workbook to another workbook, and its working very well,

Please Login or Register  to view this content.

but when i am trying to paste data to a table then is pasting data from last cell of table not in the table,

my table range is A9:S300 And i want pate data from a9 to last blank cell ( for example if last cell is a20 then from a20 )
this code is pasting data from a301 but should be paste in table range


please help to solve this
thanks in advance

[Sintek]

See Top Yellow Banner