Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when selecting date range.
I have a little piece of code that worked in one workbook, however;
when I copied it over to another workbook I get the following error: Run-Time error '1004': Method 'Range' of object '_Global' failed The code used copies to a column based on the date with the date range starting in B3 and going until AF3. It selected the range correctly, but just fails. What I don't understand is why the exact same code will work in one workbook and not in another. Of note the Macro's are held in a seperate workbook that opens a total of 3 other workbooks. The workbook and worksheet that uses the code are the active workbook/ worksheet. Here is the code used: Sub COPY_PASTE() ' Range("AI7:AI299").Select Selection.Copy Application.Run ("DateColumn") Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub Sub DateColumn() Windows("WORKBOOK.XLS").Activate Sheets("WORK SHEET").Select Range("B3").Select Range(Selection, Selection.End(xlToRight)).Select Selection.Find(What:=Range("DATE"), After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ActiveCell.Offset(4, 0).Select End Sub Any help will be greatly appreciated. Thanks, Christopher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting data within a date range | Excel Worksheet Functions | |||
Runtime Error 1004 on selecting range | Excel Programming | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
1004 error when selecting a range | Excel Programming | |||
Error 1004 when selecting a range | Excel Programming |