Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 20th, 2007, 05:19 AM
Registered User
 
Join Date: Dec 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to samuel2680
Default Macro problem !!

I have a macro, but when i try to execute it in excel i always get the error run-time error '438'
(object doesn't support this property or method) why?

This is the macro:

Sub Vai_A()
    '
   ind_fo = Sheets("START").DropDowns(1).Val + 1
   nome_fo = Sheets("Lis_fogli").Cells(ind_fo, 1)
   Sheets(nome_fo).Activate
   If nome_fo = "Frontespizio" Then
    Columns("A:M").Select
    Range("M1").Activate
    ActiveWindow.Zoom = True
    Range("A2").Select
   ElseIf nome_fo = "Sinottico" Then
     Columns("A:AM").Select
    Range("AM1").Activate
    ActiveWindow.Zoom = True
    Range("A1").Select
   ElseIf nome_fo = "Guida" Then
     Columns("A:E").Select
    Range("E1").Activate
    ActiveWindow.Zoom = True
    Range("A1").Select
   Else
    Columns("A:Q").Select
    Range("Q1").Activate
    ActiveWindow.Zoom = True
    Range("A1").Select
   End If
End Sub
End Sub

Can someone help me, please.
 







Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with a Macro vbanovice Excel VBA 1 September 26th, 2008 02:47 PM
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
Outlook macro Russ Thompson Beginning VB 6 0 October 20th, 2004 01:02 PM
Macro Help! Jolin VB How-To 0 April 22nd, 2004 08:38 AM
Macro KennethMungwira Access 1 June 13th, 2003 12:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.