Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select method of range class failed problem
Hi,
I have the following code in the Masterdata Worksheet_activate event. I want Range a1 to be selected when the worksheet is activated: Private Sub Worksheet_Activate() ActiveWindow.DisplayGridlines = False Worksheets("Masterdata").Range("a1").Select ActiveWindow.Zoom = 85 End Sub I get error "select method of range class failed" . Please help. Thanks in advance. Regards, Raj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select method of range class failed problem
Try this:
Private Sub Worksheet_Activate() Range("a1").Select With ActiveWindow .DisplayGridlines = False .Zoom = 85 End With End Sub Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "Raj" wrote in message ... Hi, I have the following code in the Masterdata Worksheet_activate event. I want Range a1 to be selected when the worksheet is activated: Private Sub Worksheet_Activate() ActiveWindow.DisplayGridlines = False Worksheets("Masterdata").Range("a1").Select ActiveWindow.Zoom = 85 End Sub I get error "select method of range class failed" . Please help. Thanks in advance. Regards, Raj |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select method of range class failed problem
Try:
Me.Range("a1").Select Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select method of Range class failed | Excel Programming | |||
Select method of Range class failed | Excel Programming | |||
Select method of Range class failed - but why??? | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming |