Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pastespecial code
Please help!
I have the following code that copies and pastes cell values from one sheet to another based on a line number that is entered by the user. For some reason, VB claims the last line with the pasteSpecial operation has incorrect syntax. It is asking me to set it equal to an expression (!?!). I must be doing something wrong but it looks just like the example, and TagInfo is a valid range. What am I missing? Dim LineInfo As Range Dim TagInfo As Range Dim TargetLine As Integer TargetLine = Sheets("Tag Entry").Range("F6").Value Set LineInfo = Sheets("Tally").Range("E2:J2").Offset(TargetLine, 0) Set TagInfo = Sheets("Tag Entry").Range("C6:C11") 'Copy and paste line info for the selected line LineInfo.Copy TagInfo.PasteSpecial(xlPasteValues,xlPasteSpecialO perationNone,False,True) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PasteSpecial | Excel Programming | |||
Code for meet cond, copy, pasteSpecial, ValuesOnly | Excel Programming | |||
PasteSpecial | Excel Programming | |||
PasteSpecial | Excel Programming | |||
pastespecial | Excel Programming |