using macro IE turns error...

B

bduzenli

I have an Excel spreadsheet that contains some VBA macros
to select some rows. This file works fine in Excel. But in the interne
explorer spreadsheet turns an error messages and dont work fine.
Error is here: Run-time Error: '1004' Method of 'Rows' object '_Global
failed.
Error occurs when command line: Rows("4:45").Select

Thanks for all.

Note: I must use internet explorer because the excel file on ou
intranet.

Bilal DUZENLI

From TURKEY....

:
 
Q

quartz

Bilal

The following works for me
However, I am manipulating the control named "SS1" on a work sheet in Excel:

Dim objSS As OLEObjec
Set objSS = ActiveSheet.OLEObjects("SS1"
objSS.Object.Rows("4:45").Selec

Maybe this helps somehow??
 
Top