Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can somebody explain what this code is doing. I just don't understand it.
This is from an existing macro; I understand the code but not these sections of it. I need to alter my macro but don't dare until I understand all sections of it. Thanks Set rng1 = Intersect(rng.EntireRow, .Columns(1).Resize(, 4)) Set rng2 = Intersect(rng.EntireRow, .Columns(2)) Set rng3 = Intersect(rng.EntireRow, .Columns(1).Resize(, 2)) Set rng4 = Intersect(rng.EntireRow, .Columns(4)) rng1.Copy rng3.Offset(0, -1) rng2.Copy rng3.Offset(0, 2) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FORMULA EXPLANATION | New Users to Excel | |||
Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Explanation needed for CopyAllModules code | Excel Programming | |||
Explanation of code | Excel Programming | |||
Explanation of code | Excel Programming |