+ Reply to Thread
Results 1 to 1 of 1

Save and restore (or transfer) a range's format properties

  1. 07-24-2019, 05:59 PM #1
    Warbe
    Warbe is offline
    Registered User
    Join Date
    08-22-2011
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    51

    Save and restore (or transfer) a range's format properties

    The below procedure saves and restores all format properties of a given range which may be a single cell, merged cells, etc. If the restore range is not the save range the format properties are transferred/copied.
    Usage Code (Selection is used here but may be any range):
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by Warbe; 07-30-2019 at 05:29 PM. Reason: ErrHndlr updated
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Workbook will no longer Save or Restore
    By thorrrr in forum Excel General
    Replies: 3
    Last Post: 04-25-2019, 12:26 PM
  2. Save and restore Date Filters in vba
    By hiici in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2018, 06:19 PM
  3. [SOLVED] How to save (and then restore) the selected cell on a different worksheet
    By Ed_Collins in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-16-2015, 03:31 PM
  4. [SOLVED] Restore a previous save?
    By rhenry2424 in forum Excel General
    Replies: 3
    Last Post: 09-28-2013, 03:05 PM
  5. Using an INI to save and restore check box values
    By SystemsAccountant in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-19-2010, 04:56 PM
  6. On hard drive, how do I restore .XLS prior to last save?
    By wondervic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2005, 04:05 PM
  7. [SOLVED] always save back up, save as, tools, properties
    By Kenlyn in forum Excel General
    Replies: 3
    Last Post: 02-27-2005, 11:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1