I lost my formatting after pasting a range from another sheet w/in a workbook into an other sheet. Here's my code:I had successfully copied all the data and the formula except the formatting. Thanks in advance!VB Code:
shtSrc.Range("A1:Z10").Copy shtDest.Range("A" & nS).PasteSpecial xlPasteAll Set rangeX = shtDest.Range("A" & nS & ":L" & nE)




Reply With Quote