View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Pannozzi James Pannozzi is offline
external usenet poster
 
Posts: 1
Default "Object Required" Error in Excel 2000 but Not in Excel 97 (!?)

The following line (see below) works fine in Excel 97
but gives an "Object Required" message in Excel 2000.

(Note that this is VBScript, not VBA)

Set mg = xcel.ActiveSheet.Columns(1).Find("Info Schedule")

I tried preceeding the errored line above with
DIM mg but the error still occured.

Does anyone know what might be causing the error?

Thanks
Jim