in reply to Moving Excel cells from one worksheet to another

If you are on Windows, you can use Win32::Ole and do copy/paste special values&formats. This would preserve all the formatting. If you are sure you have no formulae, then simple paste will do.

  • Comment on Re: Moving Excel cells from one worksheet to another

Replies are listed 'Best First'.
Re^2: Moving Excel cells from one worksheet to another
by TravelAddict (Acolyte) on Apr 30, 2013 at 16:12 UTC
    Thanks for your reply, hdb! I never used Win32::OLE but after a first look it seems to be promising. I'll explore and give it a try!