• Code Snippets

  VBA Code schneller machen

  Posted by Excel Community on 5. September 2024 at 12:10

  Füge diesen Code in deine Prozedur ein um sie schneller zu machen:

  
  
  With Application
  
    .ScreenUpdating = False
  
      .Calculation = xlCalculationManual
  
      .EnableEvents = False
  
  End With
  
  'Code hier einfügen:
  
  With Application
  
      .ScreenUpdating = True
  
      .Calculation = xlCalculationAutomatic
  
      .EnableEvents = True
  
  End With

  Excel Community replied 4 months, 2 weeks aktiv. 1 Member · 0 Replies

  • VBA
• 0 Replies

Log In to Reply