Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good afternoon, Can someone please explain why I'm getting a runtime
errror on the following code: ' I declared the workbook and worksheet in the beginning of the program: Dim volume_WB as Workbook Dim volume_sheet as Worksheet ' I open the workbook Set volume_WB = Workbooks.Open("DASD.volumes.test.xls", UpdateLinks:=0) ' I call a routine to pass the workbook Call dasdType(site, frowV2X, frowSHK, volume_WB, volume_sheet) ' site = a 2-character desgination. it will be either HQ or NE ' The program bombs on the first line: Set volume_sheet = volume_WB.Sheets(site & "-V2X") What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime error '424': Object Required | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
Runtime error 424 - Object required | Excel Programming | |||
runtime error ....object required | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |