ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Object Required" Error in Excel 2000 but Not in Excel 97 (!?) (https://www.excelbanter.com/excel-programming/298601-object-required-error-excel-2000-but-not-excel-97-a.html)

James Pannozzi

"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




All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com