Consulting

Results 1 to 14 of 14

Thread: VBA - Help me to solve this one, makro who can select between 3 sheets

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBA - Help me to solve this one, makro who can select between 3 sheets

    Can anyone see why a get a " time error 9 " when a try to activate the last sheet whit selection "1" ?
     Sub TEST()'
    ' TEST Makro
    
      If Range("N20") = "3" Then
      Sheets("Sammenligning pf og pg").Select
      ElseIf Range("N20") = "2" Then
      Sheets("Sammenligning s og pg").Select
      ElseIf Range("N20") = "1" Then
       Sheets("Sammenligning s og pf").Select
    
    
      End If
    
    End Sub
    Last edited by SamT; 01-04-2018 at 05:09 PM. Reason: Formatted Code via Hash Tag icon

Posting Permissions

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