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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error using offset
The line .Offset(1, 0).Select needs to qualified by a preceding With statement. Eg., With Selection .Offset(1,0).Select End With or just Selection.Offset(1,0).Select Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Mon, 22 Feb 2010 13:43:45 -0800 (PST), "J.W. Aldridge" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error using offset
Your error was caused by the line being too long and you didn't use a line continuation character (underscore) to joingn the line. Here is how I would write the macro Sub APPLES() 'COPY OP FNAME & PASTE With Sheets("Correct") LastRow = .Range("G2").End(xlDown).Row Range("G2:G" & LastRow).Copy End With With Sheets("Errors") LastRow = .Range("AA" & Rows.Count).End(xlUp).Row Newrow = LastRow + 1 Range("AA" & Newrow).PasteSpecial _ Paste:=xlValues End With End Sub -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181580 Microsoft Office Help |
Reply |
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 |