Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying static cells in a loop....Paste Special problems
Here is my query:
' Detail Machine Code, PCI, and Agreement type Column 'Set ws1 = Worksheets("Calc") 'Set ws2 = Worksheets("Generator") Dim lastrowDMC As Long Dim rDMC As Long, rrDMC As Long rrDMC = 14 Dim DMC As Long DMC = Range("I11").Copy With ws2 lastrowDMC = .Cells(Rows.Count, "B").End(xlUp).Row For rDMC = 14 To lastrowDMC Range("I11").Select Selection.Copy ws2.Cells(rrDMC, "C") = Selection.PasteSpecial '_ 'Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False rrDMC = rrDMC + 1 Next rDMC End With It is supposed to take the cell I11, and copy it, adn then paste it in a loop to the column C starting at row 14, and then going down the column to the last row I counted....However, I can't get it to do a pastespecial..it keeps putting a value of "true" in the cells since I11 is a formula. I get a syntax error if I uncomment the Paste:x1PasteValues.. line. Help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying static cells in a loop....Paste Special problems
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying static cells in a loop....Paste Special problems
Yep..sorry about this..I submitted it at 11:30, and it just showed up.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Special problems | Excel Discussion (Misc queries) | |||
Excel 2003 -- Copying a formula to Paste Special into column cell | Excel Discussion (Misc queries) | |||
Copying a forumula to many cells -but keeping one element static | Excel Worksheet Functions | |||
preparing pivot fields for copying and paste special for sorting | Excel Discussion (Misc queries) | |||
Special Cells to Loop back | Excel Programming |