Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dim myRange As Range
ActiveWorkbook.Sheets("hello").Select Range("L2").Select myRange = Range(Selection, Selection.End(xlDown)).Select myRange2 = myRange.Offset(0, 11) myRange2.Select Selection.Copy Sheets("solong").Select Range("b101000").Select Selection.End(xlUp).Select Selection.Offset(1, 0).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False the problem is that the macro is falling over with the range in column L selected. the offset selection is not made. is there a problem with the sytax? thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range copying macro question | Excel Discussion (Misc queries) | |||
Offset function problem-Dynamic range | Excel Discussion (Misc queries) | |||
Offset Question | Excel Worksheet Functions | |||
Problem with Slow ReCalculation of Dynamic Range Using OFFSET | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions |