Dynamic Database copying

hi i want to copy using dynamic range my code is as follows

Please Login or Register  to view this content.

it gives object error i want to do something of this type using varColumn this works fine when using column c or some defined one i have attached the workbook

hi,

Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Edit:
Btw where do you set the value of strName?

Steffen Thomsen