Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut and paste using absolute references in vba
A B C D
1 start time 2 5 2 X 3 3 4 Y 3 6 3 Z The cursor is at D2. What is the code to cut and paste values in column C - X to I2:J2, Y to G3:J3 and Z to J4:J6? Hope this is understandable. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut and paste using absolute references in vba
Sub BuiltData()
for each cell in Range("C2:C4") cell.Offset(0,cell.offset(0,-2).Value+1). _ Resize(1,cell.offset(0,-1).Value).Value = cell.Value cell.ClearContents Next End Sub Assume Z to J4:J6 should say Z to J4:K4 -- Regards, Tom Ogilvy "Stewart" wrote in message ... A B C D 1 start time 2 5 2 X 3 3 4 Y 3 6 3 Z The cursor is at D2. What is the code to cut and paste values in column C - X to I2:J2, Y to G3:J3 and Z to J4:J6? Hope this is understandable. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Absolute References | Excel Discussion (Misc queries) | |||
Absolute References | Excel Worksheet Functions | |||
transpose absolute references | Excel Programming |