Results 1 to 9 of 9

Thread: copy properties in Excel

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2005
    Posts
    4

    Resolved copy properties in Excel

    Excel makes me crazy I need to make identical copy of cell.
    I need something like
    VB Code:
    1. Worksheets("Sheet1").Cells(1, 1) =  Worksheets("Sheet1").Cells(1, 2)

    but it copyes only value, but I also need fonts, borderds, etc ..

    How can I do it?
    Last edited by vgray; May 1st, 2005 at 03:13 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width