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....

:
 
G

Guest

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error when running an excel 2004 macro in excel 2000 2
"Run-time error '1004' 5
Macro that moves to a cell using two variables See below 5
Run-time Error '1004': Selection is too large. 0
Is there a limit to the number of items you can select? 6
Excel macro error when workbook is shared 0
Run-time error 1004 6
error 1004 8

Top