copy destination with variable worksheet names

[Maglor]

Hello Everyone,

in the code below im getting a type mismatch error where it sets ws3. the code actually shows the right value when i scroll over it in debug mode and im unsure how to resolve the problem.

Please Login or Register  to view this content.

any assistance would be greatly appreciated
Regards
Mag

[Maglor]

for anyone else out there with a similar problem, i changed the order of the defining and instead of trying to call it by name i used the active sheet method.

see code below

Please Login or Register  to view this content.

for the few people who took an interest
Cheers
Mag