| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using macro IE turns error...
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 he 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.... : -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using macro IE turns error...
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
| Text turns into #### | Excel Discussion (Misc queries) | |||
| 8-10 turns in 8 oct | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
