in reply to Re: Unable to retain the format in copying from one excel file to another
in thread Unable to retain the format in copying from one excel file to another

I have posted the solution on stackoverflow
Please see the below link

Thank you very much for the update, but why not post the code here as well for some extra XP? ;-)

  • Comment on Re^2: Unable to retain the format in copying from one excel file to another

Replies are listed 'Best First'.
Re^3: Unable to retain the format in copying from one excel file to another
by nemadepsn (Initiate) on Jul 19, 2019 at 06:02 UTC

    I didn't know that. I will do that. Thanks for the info :)