Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last cell, copy, paste special, loop
Need help with the following:
I have data (equations) in columns P and Q. I need to copy and paste special values the values in P2 and Q2 to R2 and S2. I know simple... But there are a few thousand rows of data and the data in columns P and Q are based on equations that change based on how far down the R column is filled down. Currently I have something like this.. Range("r1", Range("r1").End(xlDown)).Offset(2, -2).Resize(1, 2).Copy Range("r1", Range("r1").End(xlDown)).Offset(2, 0).Resize(1, 2).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False But it doesn't go to the next set of cells after the initial copy and paste. I also need to Loop this process for all rows. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
For next loop and paste special Help please | Excel Programming | |||
Create new sheet from cell-info and then copy/paste special | Excel Programming | |||
Copy Paste Special Link Cell Problem | Links and Linking in Excel | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |