Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Unexpected Error

I recorded the following code in the macro recorder but when I run it all
methods fail giving a similar message

Run Time 1004 - Method 'Left' of object '_application' failed

Any clues ?

TIA
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Unexpected Error

Show us you macro and tell which line cause the error.

Regards,
Per

On 10 Aug., 03:28, K_Macd <kmacdonald "A_T" activ8
''''''''''''''''''''''''''''''''D O T''''''''''''''''''''''''''''''''
net [S wrote:
I recorded the following code in the macro recorder but when I run it all
methods fail giving a similar message

Run Time 1004 - Method 'Left' of object '_application' failed

Any clues ?

TIA
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default Unexpected Error

You forgot to post the code.


"K_Macd" <kmacdonald "A_T" activ8 ''''''''''''''''''''''''''''''''D O
T'''''''''''''''''''''''''''''''' net [S wrote in message
...
I recorded the following code in the macro recorder but when I run it all
methods fail giving a similar message

Run Time 1004 - Method 'Left' of object '_application' failed

Any clues ?

TIA
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Unexpected Error

Oops - bit quick off mark

Sub HalfWindow()

Application.Left = 6
Application.Top = 3
Application.Width = 645
Application.Height = 780

End Sub

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"JLGWhiz" wrote:

You forgot to post the code.


"K_Macd" <kmacdonald "A_T" activ8 ''''''''''''''''''''''''''''''''D O
T'''''''''''''''''''''''''''''''' net [S wrote in message
...
I recorded the following code in the macro recorder but when I run it all
methods fail giving a similar message

Run Time 1004 - Method 'Left' of object '_application' failed

Any clues ?

TIA
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time error '50003': Unexpected error Jack Excel Programming 6 March 22nd 09 05:19 PM
Solver Error - an unexpected internal error has occurred Steve Excel Discussion (Misc queries) 1 February 12th 09 03:18 AM
Solver Error - an unexpected internal error has occurred Steve Excel Discussion (Misc queries) 0 February 12th 09 02:35 AM
Solver Error - an unexpected internal error has occurred Steve Excel Discussion (Misc queries) 0 February 12th 09 02:19 AM
Solver Error - an unexpected internal error has occurred Steve Excel Discussion (Misc queries) 0 February 12th 09 02:19 AM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"