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

Sub HalfWindow()

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

End Sub

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"

It won't work on a maximised window, add
Application.WindowState = xlNormal
before the first of your 4 statements.

K_Macd;454912 Wrote:
I recorded the following code in the macro recorder but when I run it
all
methods fail giving a similar message

Sub HalfWindow()

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

End Sub

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"


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125926