Format one Page from another

[trevor2524]

Hello I have the following code that is being run from a command Button on the sheet called "Poss Dupes". I want it to format the sheet called "Import" Unfortunately I'm getting an error and the following line

Please Login or Register  to view this content.

Here is the complete code:

Please Login or Register  to view this content.

Can somebody point out my mistake or a better way to do this. Thank you.

[pareshj]

Hi Trevor2524,

Check the below code and hope this will help you.

Please Login or Register  to view this content.

Regards,
Paresh J