Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error using offset
compile error:
invalid or unqualified reference Sub APPLES() 'COPY OP FNAME & PASTE Sheets("Correct").Select Range("g2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("Errors").Select Range("AA6500").Select Selection.End(xlUp).Select .Offset(1, 0).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET and LOOKUP Error | Excel Worksheet Functions | |||
Error in Function OFFSET | Excel Worksheet Functions | |||
Offset/match returns #value error | Excel Worksheet Functions | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Range Offset Error | Excel Programming |