Results 1 to 5 of 5

Thread: Format lost after pasting range

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member dRAMmer's Avatar
    Join Date
    Oct 2001
    Location
    strangelans
    Posts
    463

    Resolved Format lost after pasting range

    I lost my formatting after pasting a range from another sheet w/in a workbook into an other sheet. Here's my code:
    VB Code:
    1. shtSrc.Range("A1:Z10").Copy
    2.    shtDest.Range("A" & nS).PasteSpecial xlPasteAll
    3.    Set rangeX = shtDest.Range("A" & nS & ":L" & nE)
    I had successfully copied all the data and the formula except the formatting. Thanks in advance!
    Last edited by dRAMmer; Mar 1st, 2006 at 07:58 PM.
    live, code and die...

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