Results 1 to 4 of 4

How to fix Run time Error 9

Threaded View

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016,office 365
    Posts
    69

    How to fix Run time Error 9

    Dear Experts
    I am facing "Run time error 9 Script Out of Range" when I open xlsm files. I am using this below code in sheet Tab named as "Project".How to fix that rectify that?
    Private Sub Worksheet_Calculate()
    If Range("I1").Value = "True" Then
        Worksheets("Dashboard").Range("R10").EntireRow.Hidden = False
    ElseIf Range("I1").Value = "False" Then
        Worksheets("Dashboard").Range("R10").EntireRow.Hidden = True
    End If
    If Range("J1").Value = "True" Then
        Worksheets("Dashboard").Range("A3, A15:A19").EntireRow.Hidden = False
        Worksheets("ICT").Range("k:k").EntireColumn.Hidden = False
        Worksheets("Vehicle").Range("O:O").EntireColumn.Hidden = False
    ElseIf Range("J1").Value = "False" Then
        Worksheets("Dashboard").Range("A3,A15:A19").EntireRow.Hidden = True
        Worksheets("ICT").Range("k:k").EntireColumn.Hidden = True
        Worksheets("Vehicle").Range("O:O").EntireColumn.Hidden = True
    End If
    End Sub
    Last edited by krishnakuma6; 11-30-2016 at 04:39 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Error message: Run-Time error '1004 '; application-defined or object-defined error
    By Davasu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2015, 06:52 AM
  2. Replies: 1
    Last Post: 10-22-2015, 05:50 AM
  3. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  4. Cannot Publish Excel Pivot Chart - Run Time Error
    By crisb184 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 07:04 AM
  5. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  6. run-time error ;2147023179 (800706b5) time automation error interface unknown
    By karthik72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 09:31 AM
  7. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1