Results 1 to 3 of 3

How to copy cell formats from a sheet

Threaded View

Barcode How to copy cell formats from... 09-10-2009, 03:58 AM
JBeaucaire Re: How to copy cell formats... 09-10-2009, 07:01 AM
Barcode Re: How to copy cell formats... 09-10-2009, 08:23 AM
  1. #1
    Registered User
    Join Date
    09-07-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    19

    How to copy cell formats from a sheet

    In a macro, I am copying data from another sheet and most of the time I only require the actual data or the values as per below.

    .Offset(1, 0) = Worksheets("Main").Cells(7, 3).Value
    But sometimes I want to also copy the Formats of the cell eg. color etc.
    How do I go about doing this please?
    Last edited by Barcode; 09-10-2009 at 08:25 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1