Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste code
I can't seem to get this code to work. I am trying to set up a spreadsheet
that copys a range from one sheet and adds to the values on an identical sheet. The problem is some of the cells are merged and my code unmerges them, despite that when I do it manually, it works. Here is my code: Sheets("Entry").Activate Range("B5:Q13").Copy Sheets("Total").Activate Range("B5:Q13").PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Sheets("Entry").Activate Range("T5:AG13").Copy Sheets("Total").Activate Range("T5:AG13").PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Basically I am tallying the numbers that are entered in the first sheet. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste using vb code | Excel Discussion (Misc queries) | |||
copy and paste formula using vb code | Excel Discussion (Misc queries) | |||
Got the Copy/Cut Code But what is the Paste Code | Excel Programming | |||
Help-Copy&Paste code | Excel Programming | |||
Need Help with Code - Copy & Paste | Excel Programming |