ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unexpected Error (https://www.excelbanter.com/excel-programming/432205-unexpected-error.html)

K_Macd

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"

Per Jessen[_2_]

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"



JLGWhiz[_2_]

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"




K_Macd

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"






All times are GMT +1. The time now is 03:54 PM.

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