Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I try and copy a selection of cells my code throws the following code
Runtime Error 424: Object Required Any Ideas? Here is part of my code For a = 1 To ACount mainworkbook.Activate Sheets("List").Cells(a*20, 1).Select Range(ActiveCell, ActiveCell.Offset(-19, 5)).Select Selection.Copy ' THIS IS WHERE THE ERROR OCCURS secondaryworkbook.Activate Sheets(a).Cells(1, 1).Select Selection.Paste Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error 424 : Object required | Excel Programming | |||
Object required error... | Excel Programming | |||
Error: Object required | Excel Programming | |||
Object required error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |